How to get output as unique rows by comparing two columns using LINQ query

[Gokul001 (Gokul Balaji)]

Hi @chanbhasha.p

How about this following expression?

dataTable = dtinput.AsEnumerable()
.GroupBy(Function(i) i.Field(Of String)(“columnWithDuplic”))
.Select(Function(g) g.First)
.CopyToDataTable

Regards
Gokul