Removing Duplicate Rows Based on Column Value

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @elliot.barling

refer below.. It has LINQ query, that should work.. Otherwise you can also try few other solutions mentioned in there..

dt.AsEnumerable().GroupBy(Function(r) r.Field(of String)("<Col Name>")).Select(Function(s) s.First()).CopyToDataTable - This can be used to remove all dups with in the specified column.

dt.DefaultView.ToTable(True) - It will create a new Datatable with unique rows with respect to every column.

Both return a new Data table with no dups.

Remove Duplicate Rows based on Column

You can use LINQ statements to do remove dups. Like dt.AsEnumerable().GroupBy(Function(r) r.Field(of String)("<Col Name>")).Select(Function(s) s.First()).CopyToDataTable - This can be used to remove all dups with in the specified column. dt.DefaultView.ToTable(True) - It will create a new Datatable with unique rows with respect to every column. Both return a new Data table with no dups.