Filter data Excel

Help
, , ,
1

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?

2

@TanVuong

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

Example of select query.

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

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.
Ex:
A B
1 1
2 2
2 3
3 5
5 4
4

4

Hi @TanVuong
Use this

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

Thanks
ashwin S

5

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