Data table how to remove duplicate rows

@AJITH_SK

Can you try the below

image

DT.AsEnumerable() _
    .GroupBy(Function(row) row.Field(Of String)("Name") & row.Field(Of Integer)("Age") & row.Field(Of String)("City")) _
    .Select(Function(Group) Group.First()) _
    .CopyToDataTable()

Output:

image

Cheers!!

2 Likes