Need to remove duplicates on single column

[manojmanu.rpa]

i want to remove duplicates only for a single column. please help

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @manojmanu.rpa
Remove duplicate rows activity can be used

Activities - Remove Duplicate Rows

0r

Removing duplicates in the same column

Hi! I’d like to remove duplicate items in the subsequent rows, but not sure what is the ideal way to do it? I have tried assigning rows = row.Item(0).ToString.Contains(Items) and then using if row 1 = row 2 then duplicate. But if I have 100 rows, it doesn’t seem to be the most feasible way. [image] In this example, I just want to remove James’s row because Apple has already been taken by Sam. Please help!

[sreejith.ss]

Hey @manojmanu.rpa please try this linq query.
dtTable.AsEnumerable.GroupBy(function(x) x(columnname).ToString).Select(function(y) y.First).copytodatatable

It will help you to select the unique value from the column

Regards

Sreejith S S

[manojmanu.rpa]

Thanks @sreejith.ss
These is the input i have to give

and output need to come like this

based on invoicedate col i have to merge commented reasons into one cell, can you please help in that.

Regards,
Manoj

[Anil_G (Anil Gorthi)]

Hi @manojmanu.rpa

Can you try this

Use in Assign

dt = (From d In dt.AsEnumerable
Group d By k=d("invoicedate").toString.Trim Into grp=Group 
Let n = grp.Select(Function (rn) rn("PO").toString).FirstOrDefault
Let s = String.Join(";", grp.Select(Function (rn) rn("Commented").toString).toArray)
Let ra = New Object(){k, s, n}
Select dt.Rows.Add(ra)).CopyToDataTable

dt is the datatable in which data is present

Cheers

[manojmanu.rpa]

it’s works. Thanks @Anil_G

Regards,
Manoj.