Want a solution

[Shubham_Bidwai]

i have excel sheet having number of columns like (Name,Task,comment,remark,etc)
but in name columns have same name but i want one name for multiple name that is they did not accept duplicate name for that column and merge the other data like task and comment is merge with that name

[Jithesh_R (Jithesh Karkera)]

Hii @Shubham_Bidwai ,
Can you please share your sample input and the expected output?

Regards,

[Shubham_Bidwai]

@Jithesh_R
input

output

[supermanPunch (Arpan)]

Duplicate :

I want solution of my issue

Hi @Shubham_Bidwai , Check with the below Steps : Read the Excel Sheet as a Datatable using Read Range Activity. Get the Datatable, say DT. Next, Create another Datatable to create the Output data, say OutputDT. Assign the clone of the Input datatable to this Output Datatable like below using an Assign Activity. OutputDT = DT.Clone Next, we’ll use the below Linq in an Assign Activity to Group By and Concatenate the values based on the Column Name : OutputDT = (From d In DT.AsEnumer…

[Manish540 (Manish Shettigar)]

Hi @Shubham_Bidwai ,

Please check this below code,

First assign :-
dt_Final = dt_Input.Clone()

Second assign :-

dt_Final = (From x In dt_Input 
Group x By k=x("Name").tostring.trim Into grp=Group
Let ma = String.Join(Environment.NewLine, grp.select(Function(y) y("Task").tostring.trim).ToArray())
Select dt_Final.Rows.Add(New Object(){grp(0)("Name").ToString,ma})).CopyToDatatable()

Hope this helps you

[Jithesh_R (Jithesh Karkera)]

Hii @Shubham_Bidwai ,
Give a try to this.
CombineDuplicateRows.zip (2.6 KB)

Output :

Hope this will help you ,
Thanks

[Shubham_Bidwai]

@Jithesh_R
input:

output:

[Jithesh_R (Jithesh Karkera)]

Hii @Shubham_Bidwai ,
whats happening?

[Shubham_Bidwai]

@Jithesh_R add more coloumn in sheet and they are also merge

[Jithesh_R (Jithesh Karkera)]

Hii @Shubham_Bidwai ,
Please find the updated workflow .
CombineDuplicateRows.zip (2.9 KB)

Hope this helps
Cheers