Removing duplicates based on one Column

Help Forum
2

Hi @mz3bel

How about this expression ?

DtOutput = DtBuild.Clone

(From d In DtBuild.AsEnumerable
Group d By k=d("Col A").toString.Trim, k2=d("Col B").ToString.Trim Into grp = Group
Let ra = New Object(){k,k2}
Select r = DtOutput.Rows.Add(ra)).CopyToDataTable

Regards
Gokul

4 Likes