How to Remove Duplicate Columns in Excel and have the distinct values in the other sheet

[tgopalas (Tanuja)]

Hi,

Thanks in Advance

[Dominic]

@tgopalas, This one, kindly refer/search for (an existing solution).

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,
Dom

[tgopalas (Tanuja)]

@Dominic The code didnt worked , The Duplicate values are not coming . The same Table with all the values are coming as an output

PFADates.xlsx (8.0 KB)
Add billd.xaml (9.5 KB)

[Dominic]

@tgopalas, Have you used this query ?

DataTable distinctValues = Defaultview.ToTable(true, "Column1", "Column2" )

Regards,
Dom

[tgopalas (Tanuja)]

Yaa…but i didnt understand what is defaultview over ther

[arivu96 (Arivazhagan A)]

Refer this

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)< >''"…

DataTableName =DataTableName.DefaultView.ToTable(true,"Column1", "Column2" )

Regards,
Arivu

[Dominic]

@tgopalas, Dataview - different views of the data stored in a DataTable

Reference
Select Distinct and obtain all row of it - #11 by aksh1yadav

Regards,
Dom

[ashutoshkhantwal]

Hello Dominic, could you explain this in a bit detail, I could not find a way to use this since when I read the excel it first generates a duplicateNameException before moving pon to the further activities.