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
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.
DataView view = new DataView(table)
DataTable distinctValues = view.ToTable(true, "a")
and then use write range
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.