Remove DataTable Duplicate based on one column, keep the last occurrence

[pravin_calvin (pravin kumar)]

Hi @Hurmet_Noka

Check with the Below thread and Use Distinct function instead of first!

Remove Duplicates with LinQ

Hi there @jereed, I believe you will need to regroup and select, as shown below: dtMyDataTable = dtMyDataTable.AsEnumerable.GroupBy(Function(x) x.item("SomeColumnName")).Select(Function(i) i.First).GroupBy(Function(x) x.item("SomeOtherColumnName")).Select(Function(i) i.First).CopyToDataTable This appears to work, though there may be a more aesthetically pleasing method Thanks, Josh

Regards