Need to remove the duplicate column from excel

[Sugumar8785 (Sugumar Ramachandran)]

@Omkar_Deshmukh Please find below thread,

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]