Remove duplicate row from 2 excel files

[kohbc]

Hi,

I have 2 excel files. One of the excel file (reference file) is the list of names that I want to compare with the other excel file (student list). I’ll like to remove the duplicate row from student list when the name match the reference file.

Any ideas or suggestions on how can I do it?

Thanks.

[Pablito (Pawel Wozniak)]

Hi @kohbc,
Welcome to the Community!
There is exact same topic about it from today:

Checking Duplicate rows depending on the condition

Hello Everyone, Can someone please help me to understand how we can remove the duplicate values depending on the 2 columns in Data Table and also need to copy those duplicate rows into separate Data Table. For Example: Data Table having the column name “Supplier/Customer Name” contains the Duplicate Data and also need to check the column “Credit LC” to make sure it is duplicate or not. Then need to copy the duplicate in a separate sheet. I have used the Remove Duplicate Rows Activity which i…

[AshwinS2 (Ashwin S)]

Hi @kohbc
try this

(From p in dt.Select() where( From q in dt.Select() where q(“ColumnName”).Equals(p(“ColumnName”)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()

Thanks
Ashwin S

[kohbc]

Hi Ashwin S,

I’m beginner to this uipath. I don’t understand the equation stated in your email below.

Just to be more specify to my question, I have 2 excel files (reference list and student list). The 2 excel files have a name column.
I’m using the name in column A reference list to check again the column D student list. If duplicate is found, delete the duplicate row in student list.

Could you please advice?

Thanks.

Regards,

Boon Chew

[AshwinS2 (Ashwin S)]

Hi @kohbc

Use multiple for each loop and check the condition as row(“reference_list”).tostring.equals(row (“student_list”).then use remove data row activity to delete the specific row

Thanks
Ashwin.S

[kohbc]

Hi Ashwin.S,

Thank you for your suggestion. I’ll try it.

Regards,

Boon Chew