You can use filter datatable activity and in the condition you can remove the duplicates row.
I will try it,thank youu
I hope there is no duplicate ROWS in your excel image
But still to remove the duplicate records in a excel use read range activity and get the output with a variable of type datatable named dt and We can use REMOVE DUPLICATE ROWS activity
I usually use a list variable and check if row value is in this variable, then skip the row, if not - I add value to this variable and read row
Try these steps:
- Use Read Range activity to read data from excel file and will give you output as DataTable and say ‘DT’
- Then try this expression toremove duplicates:
newDT = DT.DefaultView.ToTable(True,"Region").CopyToDataTable
- And then use Write Range activity to write into exel file and pass that newDT as input to it.