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

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

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.