Remove Excel Duplicates(Multiple Column to be Considered)

excel
duplicates

#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


#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