How to compare duplicate values in sheet1 and sheet2 of excel using uipath

Hi,
I have two excel sheets with duplicate values.I need to compare column 1 and column 2 of sheet1 with column 1 and column 2 of sheet2. I need to compare both the sheets and update the output in sheet 3. I have attached the sample excel data with this. Can somebody please help me with this.
test.xlsx (11.1 KB)

Hi Henry,
Please check the workflow. Duplicate Columns.xaml (11.7 KB)
I ignored the header manipulation for now. So please don’t use unique column names for your sheets. :slightly_smiling_face:

Warm regards,
Nimin

1 Like

Hi @Henry

You may refer below post-

Thanks for the reply, but this doesn’t work in my case. I have shown the expected output in the excel sheet.

This is to get the duplicates. What I need is I need to compare. I have shown the expected output in the excel provided.