Remove duplicate from 2 excel file

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.

hi Jun_Wei

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


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

Hi @shiva1

Remove Duplicterow From Data Table Try this…


Best Regards

Under which activity do i use the code?

Assign Activity


Best Regards

1 Like

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

Yes @Jun_Wei :slightly_smiling_face:

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

Best regards

1 Like