High level I'm trying to compare two sets of data 100k approx and identify matching records in the second file that have a later date. I can import Csv and lookup using sets but can't figure out how to consider the latest date. What is the best way to approach this? E.g
File 1
[email protected], 1/1/17
[email protected] 2/3/16
File 2
[email protected]
[email protected] 9/9/17
Record [email protected] 9/9/17 identified.
Thanks.