Linq query regarding distinct rows

[vickydas (vicky)]

hello @Shikhar_Tandon
Can you give us more details of what do you want exactly ? also can you share the excel file and its desired output form

Also check this post if thats what you need

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]