Remove only specific duplicates from datatable based on condition

[Jaiver_Estiven_Salazar_Or (Jaiver Estiven Salazar Ortiz)]

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

[Yoichi]

Hi,

Hope the following sample helps you.

Sample20221220-4L.zip (15.2 KB)

Regards,

[ahmad.sultan]

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