How to Remove Duplicate Row If the Value from two Columns matched

[ashwin.ashok ((TheCodingTheory))]

Hi @Shinjid ,

Do you want to eliminate just the duplicates or remove those entries which contain duplicates completely?

If its the former, then this ought to do the trick:

Dt_sampleData.AsEnumerable().GroupBy(Function(g) Tuple.Create(g("ID").ToString,g("Name").ToString)).Select(Function(s) Dt_sampleData.Clone.LoadDataRow(s.First().ItemArray,False)).CopyToDataTable()

And if its the former then this is the code that will help you out with that:

Dt_sampleData.AsEnumerable().GroupBy(Function(g) Tuple.Create(g("ID").ToString,g("Name").ToString)).Where(Function(w) w.Count=1).Select(Function(s) Dt_sampleData.Clone.LoadDataRow(s.First().ItemArray,False)).CopyToDataTable()

RemoveDuplicateRowsBasedOnColumns.xaml (6.8 KB)

Kind Regards,
Ashwin A.K