Remove only specific duplicates from datatable based on condition

I want to delete all duplicates on a dataTable for a specific id when a condition is meet inside a for loop, so then I can past to the next Id for example:

any help would be appreciated

thank you


Hope the following sample helps you. (15.2 KB)


Hi @Jaiver_Estiven_Salazar_Or ,

This can be done with a single assign activity.

Try this:

yourDataTable = yourDataTable.AsEnumerable().GroupBy(Function(r) r.Field(Of String)(“YourColumnName”)).Select(Function(s) s.First).CopyToDataTable