How to delete the duplicates


#1

HI @arivu96

dt.AsEnumerable().Distinct(DataRowComparer.Default).CopyToDatatable() is to remove the duplicated data row
in my case in one column i have policy no : whether if its duplicated i should remove the row from excel

please help me


#2

Hi Ramesh,
based on one column you need to remove the duplicate right?

Regards,
Arivu


#3

yes, i have column header as APNO

also pls suggest me the solution if in case header is not there


#4

Ramesh,

Refer the below link


If you want specific Column alone mention the column name