Remove Excel Duplicates(Multiple Column to be Considered)

Help
1

Hi ,
I need to remove duplicate from excel considering combination of 3 fields need to unique. If you have any sample please provide

image

Thanks

2

Use Excel Application scope and then Read Range which will copy this data into a datatable.

After that Use Remove Duplicate Rows activity that will give you the desired result

3

“Remove Duplicate Rows” - Do we have any activity like that?
I didn’t find it in my activities list

4

Here it is make sure you have all the packages installed

image

It is there with the UiPath.Core.Activities package

1 Like
5

The version Which I have is 17.1.6522.14190, Could you please check the version of UiPath.Core.Activities?

6

its 18.2.6732.32230

7

Thanks for your reply…
I am using UiPath version 2017.1
Still I can add activities package of 18.2.6732.32230?
Auto update is not happening for this version.
If you could give me some head up how can i download package externally and add will solve this prob for me…

Thanks in advance

8

Uninstall the existing package and re-install it

9

ok Thanks… I will try doing it

1 Like