Remove all of Duplicate Rows base on Single Column

[Mr.H]

Hi Everyone.

I want to remove all of duplicate rows ( not keep any duplicate row ) base on single column from datatable.

How to do that with linQ ?

Thanks in advance!

[Pradeep_Shiv]

Hi @Mr.H ,

ExtractDataTable.DefaultView.ToTable(True,“ColumnName”)

Cheers

[Mr.H]

Hi Bro.

I send the sample files as attached
Input.xlsx (8.1 KB)
Output.xlsx (8.0 KB)

[ppr (Peter Preuss)]

(From d in YourDataTableVar.AsEnumerable
Group d by k=d(YourColNameOrIndex).toString.Trim() into grp=Group
Where grp.Count = 1
Select grp.ToList).SelectMany(Function (x) x).CopyToDataTable

Handling defensive an empty result following pattern can be applied:

[Mr.H]

Thanks you Very much!