Combine row with similar data

[Nisha_K21 (Nisha)]

Hi
I have one table like

I wanted to combine the rows into one single row if it has different value in it’s value I want to merge that.
I used on query but resulted into two rows(when it has more column)
Can anyone help me to merge it into one single row based on id.

[ashokkarale]

@Nisha_K21,

Try this solution.

How to merge datatable rows based on condition

Hi @Nisha_K21 => Use Read Range Workbook to read the excel and store the output in a data table say InputDt. [image] => Use the below syntax in Assign activity: OutputDt = (From row In InputDt.AsEnumerable() Group row By id = row("id"), name = row("name"), email = row("email") Into Group Select InputDt.Clone.Rows.Add(id, name, email, String.Join(",", Group.Select(Function(r) r("token").ToString())))).CopyToDataTable() OutputDt is of DataType System.Data.DataTable => Use Write Range Workb…

Thanks,
Ashok

[Nisha_K21 (Nisha)]

@ashokkarale, I tried this solution, this will merge rows but when we have more columns this will result in two rows with merged values. Is there any other way to do this.

[ppr (Peter Preuss)]

@Nisha_K21

we have more columns

just share samples as descriptions is too general

Kindly note

• we can also group data by more then one column
• we can also define more then one group member aggregations

[ppr (Peter Preuss)]

@ppr

Kindly note

• we can also group data by more then one column
• we can also define more then one group member aggregations

Example: grouping on id And name, concatenation of the tokenNames

Assign Activity
dtResult | DataType: DataTable = dtOrigVar.Clone

Assign Activity
dtResult =

(From d in dtOrigVar.AsEnumerable
Group d by k1=d("id").toString.Trim, k2=d("name").toString.Trim into grp=Group
let ra1 = grp.First().ItemArray.SkipLast(1).Cast(of Object)
Let tj = String.Join(",", grp.Select(Function (g) g("tokenName"))
Let ra = ra1.Append(tj).toArray
Select r = dtResult.Rows.Add(ra)).CopyToDataTable

[ppr (Peter Preuss)]

@Nisha_K21

Can anyone help me to merge it into one single row based on id.

this was done there

How to merge datatable rows based on condition

Assign Activity dtResult | DataType: DataTable = dtOrigVar.Clone Assign Activity dtResult = (From d in dtOrigVar.AsEnumerable Group d by k=d("id").toString.Trim into grp=Group let ra1 = grp.First().ItemArray.SkipLast(1).Cast(of Object) Let tj = String.Join(",", grp.Select(Function (g) g("token")) Let ra = ra1.Append(tj).toArray Select r = dtResult.Rows.Add(ra)).CopyToDataTable we grouped the data on id and used the aggregated tokens from the groupmembers

[ppr (Peter Preuss)]

unclear, just share clear descriptions

• input sample
• expected output sample