Remove Duplicate Entries with exception of the first one

[ClaytonM]

Hi, (@Florent_Salendres)

One way to approach this is to ForEach col In dt.Columns
Then Assign the datatable to remove the duplicates using the solution found here:

Remove Duplicates with LinQ

Hi there, I need to remove duplicates from a DataTable using LINQ. Specifically, I need to filter out all duplicates for a single column, maintaining the initial Datatable strucutre. Other methods, such as DefaultView, do not work as they print out only one column (the one containing duplicates). Any suggestion would be highly appreciated, code examples would be terrific. Thanks in advance for your help! Nicolò

So it could be something like this:

ForEach col In dt1.Columns
Assign dataTable = dataTable.AsEnumerable()
.GroupBy(Function(i) i.Field(Of String)(col.ColumnName))
.Select(Function(g) g.First)
.CopyToDataTable

That was just a quick idea I had, but there might be another way to do it without the Loop.

Regards