How to remove duplicates in an excel

[sridhar1516 (sridhar m)]

Hi every one,
I have an excel file which contains a duplicate column. In the output i want excel file without duplicate column.
I’m attaching a sample excel file for your understanding. TestData.xlsx (9.9 KB)

Your help is much appreciated. cheers

[anil5 (Anil Kumar Bandam)]

Hi,

If you know the index of the column which is duplicate and if you want to delete it you can use
activity Remove Data column, specific which index and from which datatable you want to delete the column.

While using read range uncheck add headers option,

[nimin (nimzz)]

Hi @sridhar1516,

This would be helpful for you.

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

Regards,
Nimin