How to remove duplicates rows in excel

Help Studio
, ,
1

i have datatable… in that i have a duplicate rows

how to remove duplicates rows in datatable… ?

rows should be remove from the datatable

2

@sneha41

you can use groupby function to remove duplicates

datatable.asenumerable.group(function(r) r(“columnname”).tostring).select(function(grp) grp.first).copytodatatable

columnnames pass your columnname on which basis you want to remove the duplicates rows

3

when duplicate is measured on all columns:

When duplicated is measured on a column Set:

  • LINQ SequenceEqual with a columnset
  • LINQ GroupBy with more cols
    Group d by k1=d(“COLA”).toString.Trim, k2= d(“COLB”).toString.Trim into grp=Group
    *And also the DefaultView / Filter DataTable Approach

ColSet / single Col

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.