How to skip the duplicate rows by selecting only its first occurance?

[Dave (David Wiebelhaus)]

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]