Need assistance in comparing 2 excel files

Help Studio
, ,
1

Hi Team,

I am trying to compare 2 excel files, need to compare 5 columns.
Number of rows are different in each excel file.

Is there a way to do this apart from the nested for-each loop approach?

Preferred approach: LinQ or any other.

Thank you!

2

Hey @gopai,

You can use the join datatable activity based on that for 5 columns from the both datatable and at last you can remove the unnecessary columns.

Thanks,
Sanjit