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

Help Activities
5

Hi @chanbhasha.p

Try with is expression

Build a datatable with same format and data → name as dtData
dtResults = dtData.Clone

dtResults = (From dte In dtTable.AsEnumerable
Group dte By col1=dte(0).ToString.Trim, col2=dte(1).ToString.Trim Into Group
Select dtResults.Rows.Add({col1,col2})).CopyToDataTable

1 Like