Filter data Excel

Hi all, i’m face a challenge to filter repeat data in a column in excel.Could someone please suggest what could be the correct activity and logic require for this?


You can use Filter DataTable activity or Select Query to filter data.

Example of select query.

    newDT = inputDT.Select("[ColumnName] = 'value'").CopyToDataTable
1 Like

Thank u for support, but i want copy data from a column to another column and each value of data column only write once time.
1 1
2 2
2 3
3 5
5 4

1 Like

Hi @TanVuong
Use this

DataView view = new DataView(table)
DataTable distinctValues = view.ToTable(true, "a")
and then use write range

ashwin S

1 Like

thank for answer, i will try this, wish you have a nice day.

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