Delete of duplicates

[Krzysztof]

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:)

[1996 (Neelima G)]

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

3. 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.

Thanks,
Neelima.

[Krzysztof]

@1996

DT.DefaultView.ToTable(True,"Client").CopyToDataTable

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

[1996 (Neelima G)]

@Krzysztof

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.

Thanks,
Neelima

[Krzysztof]

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