I am working on a scenario where I have two excel sheets, One sheet contain 29k records and the other one contains 3k records. I want to compare 29k records one by one with 3k records.
For now I am reading both sheets by using read range,
using for each and iterating through excel of 29k records.
again using for each and iterating through records of 3k records.
but it is just comparing 29k records with just one record of sheet 3k record.