How to remove rows with duplicate columns

Hello @carlor
you can use linq here use this code in an Assign Activity

(From roww In DT.AsEnumerable() Group By id=New With {key .i=roww.item("col1"),key .d=roww.item("col2")} Into gg=Group Select gg(0)).copytodatatable

it’ll group the two columns in your case col1 and col2

the workflow should look like this

Group%20by%20calor

8 Likes