Remove duplicate from 2 excel file

[Jun_Wei (Learnerz)]

Hi all, how can I remove the duplicate rows from combining the 2 excel file and create another file with the duplicates removed? Thanks for the help.

[shiva1 (shiva)]

hi Jun_Wei

once try the Remove Duplicate Rows activity and in the properties give the data table name

Thanks,
Shiva

[Jun_Wei (Learnerz)]

Hi shiva1,
Thanks for the reply, is there any other alternatives other than using the Remove Duplicate activity? As the uipath version I am using does not support that activity. Thanks

[Farhan (Farhan khan)]

Hi @shiva1

Remove Duplicterow From Data Table Try this…

Duplicaterow=DataTable.DefaultView.ToTable(True,“ColumnName”)

Best Regards
Farhan

[Jun_Wei (Learnerz)]

Under which activity do i use the code?

[Farhan (Farhan khan)]

Assign Activity

Best Regards
Farhan

[Jun_Wei (Learnerz)]

Thanks, do i need to start with excel application scope?

[Farhan (Farhan khan)]

Yes @Jun_Wei

You have read Excel File by using Excel scope Activity, After that you have to remove Duplicates row from DataTable

Best regards