Remove duplicate Rows from Datatable

[Pravin_Shinde]

Hello guys,
I am using the Remove Duplicate Rows activity for remove duplicate rows, but giving error on this. Can anybody help me with this?

Source: Remove Duplicate Row

Message: Data Tabke

[pattyricarte (Patty Boy)]

Hi @Pravin_Shinde

Can you show more details to easily address the issue.

cheers

Happy learning

[md.ahtesham (Ahtesham)]

@Pravin_Shinde

just for your reference .

-Ahtesham

[kadiravan_kalidoss (Kadiravan K)]

Can you share your sample Excel sheet with dummy data…!

[Pravin_Shinde]

I am scraping data from Webpage and after that removing duplicate rows.

[Pravin_Shinde]

[md.ahtesham (Ahtesham)]

@Pravin_Shinde,

Sample solution…
Duplicate Row.zip (19.0 KB)

Ahtesham

[sharathraju489 (Sharath Raju)]

Hey

Here is a detailed article on that
# How To Remove Duplicates From Datatable In UiPath

Regards

[Dasharath (Dasharath ND)]

Hi,
I have an issue with removing duplicates in datatable.

as show in the above image.i have to remove,row with SL.NO 5, as it has different value in company column.

Thanks in advance.

[Pradeep_Shiv]

then it’s not a duplicate value!

[VladTof (Vlad)]

@Pravin_Shinde

Source: Remove Duplicate Row

In your example, you don’t have duplicate rows.

[Dasharath (Dasharath ND)]

sorry,
i mean i have to remove the row with same id,name,and country but different company.

please let me know.
thanks.

[Callos_James_AU (Jemusu (AU))]

Hello @Dasharath have you found a solution on this? Could you please share? Thanks

[Dasharath (Dasharath ND)]

Hello,

I found a solution, which might be temporary.But it works well.
concatenate column with company name and name. while passing the variable to v lookup, concatenate the name variable and company variable. instead of using v lookup in loop. this is a better option.

Regards,
Dasharath ND