Delete of duplicates

Hi All,

I have a dt, where one of my column is name of client. How to get the table with only one row for each client (delete duplicates).

Thanks for your help:)

Hi @Krzysztof,

Try these steps:

  1. Use Read Range activity to read data from excel file and will give you output as DataTable and say ‘DT’
  2. Then try this expression toremove duplicates:
             newDT = DT.DefaultView.ToTable(True,"Client").CopyToDataTable
  1. And then use Write Range activity to write into exel file and pass that newDT as input to it.

Hope this helps, if it works mark as solution.


Which activity use in point 2? - Assign not works.


Using Assign Activity Your Variable type should be datatable.

Refer below Workflow references removeduplicates.xaml (4.8 KB)

If it works,mark it as solution.


It works. Thank you. How to do it, to keep another column?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.