How to Remove duplicate by a specific Column

Learning Hub
1

Hey Guys

Thanks for always helping. This time i have a data table with data and i am trying to write into an assign activity a function that can group data where items on a particular column appears more than once.
I once had this code but i cant find it anymore and i forgot to study it.
It gives me duplicate and non duplicate values into separate data table.
Please help
Regards

2

I have this but its not doing what i want.
old_dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)(“columnWithDuplic”)).Select(Function(g) g.First).CopyToDataTable
.
what i want to do is have all duplicates in one data table and all non duplicates in another data table.

Currently i have no code for the non duplicates.

Please help

3

Thanks guys i found a link with the solution.

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.