How can I find all the values in the duplicate column and merge the duplicate rows?

[balupad14 (Balamurugan)]

Hi @Bogdan,
These posts can help 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)< >''"…

Remove Duplicates

Not a perfect solution, but if BDate is string this works.I concatenated columns to find duplicates. dtDuplicates.AsEnumerable().GroupBy(Function(x) x.Field(Of String)(“Name”)+x.Field(Of String)(“BDate”)).Select(Function(y) y.First()).CopyToDataTable()

Regards
Balamurugan.S