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.
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.