have been trying to solve this issue for days and it's driving me crazy
We have 2 data sources (excel files) in our script and would like to compare field A (from 1st Excel) with field 2 (from 2nd Excel file). Overall objective is to identify only those values that are present in both fields (in 2 different files). we don't want to create key between the two fields becaise the data files are very large and this would really slow down the Reload
I know you have many rows, however if you use Inner Join as suggested by Sergey, it should solve your problem. However, if you can create some sample rows from both the tables and expected output, it would be easy to work on quickly.