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

[Henry]

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)

[nimin (nimzz)]

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.

Warm regards,
Nimin

[ShilpiJ (Shilpi Jain)]

Hi @Henry

You may refer below post-

How to identify duplicates in excel column?

In that case, there is 2 way. Option1. Get Column A and B as Data table(dtbA) Loop at dtbA to row and assigin dtbB = dtb.select(ColumnB = row value) if dtbB has more than 2 line, that duplicate. Option2. Add countif excel formula in column C and if it is more than 2, then it duplicate. I recommend option 2 if you can add new column. Rgds, J,

[Henry]

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

[Henry]

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