How to compare 2 large excel files based on "If" condition?

[Tana20]

Hi All,

I’m using two nested loops in order to compare 2 excel files, however, it doesn’t work with large files. What is the best way to solve this efficiently?

My project:

Compare_Excel.zip (433.1 KB)

Thanks

[Tana20]

I solved it by using “Join Data Table” activity, and “Remove Data Column” to remove unnecessary columns.