Comparing 7 columns of data in excel with 7 columns of data with another excel

Hi Team,

I have a scenario where i need to compare 7 columns of data in excel1 should match exactly with 7 columns of datawith excel2.

If same,copy to excel1Result
and whatever the columns are not same ,copy to another excel

@RajeshT, Did you ever solve this problem? if not…

use read range to read both the excel1 and excel2 and then use filter DataTable activity to filter for the seven columns you need from each DataTable and then use the below activity to compare the DataTables.

1 Like

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