Merge rows in a data table

[Tanmay_V_Chetule]

I need to merge rows on the basis of MID. Please help.
Please refer SS.

[supriya117 (Supriya Allada)]

Hi @Tanmay_V_Chetule

Check once this thread:

Merge rows based on condition

Hi Guys, Please check the below scenario, I would like to know it’s possible to do: Input: [image] Output: [image] If name matches mean we need to merge the other two columns based on values. Thank you.

Hope it helps.

[Anil_G (Anil Gorthi)]

@Tanmay_V_Chetule

Welcome to the community

Please try this

1. Create an outputdt and use build datatable and create 4 string type columns
2. Use assign as below
   outputdt = (From d In dt.AsEnumerable Group d By k=d("Name").toString.Trim, k1=d("Age").ToString.Trim, k2=d("MID").ToString.Trim Into grp = Group Let g1 = String.Join(",",grp.Select(function(x) x("ID").ToString)) Let ra = New Object(){k,k1,g1,k2)} Select r = outputdt.Rows.Add(ra)).CopyToDataTable

Cheers

[Aleem_Khan (crazy bot)]

merge datatable using invoke method activity uipath rpa

You also use join activity

[Saikarthik_Gajwel]

@Tanmay_V_Chetule

Please refer below link which helps to compare and merge two datatables using linq Query

How to join two datatables using LINQ inUipath

Problem statement : we need to join two datatables based on a common column values and saves it to a new database. These are the datatables [Table1] [Table2] Here, the department column in present in both the datatables and we need to apply join condition on that column values Drag the assign activity to the workflow and write the following code [Typpe code] Here is the video Youtube: Join Datatable Using Linq in Uipath - YouTube Medium: How to join two datatables using LIN…

Happy Automation

[Tanmay_V_Chetule]

Thanks @Anil_G. It worked.
Really appreciate your help.

[Tanmay_V_Chetule]

Thank you for the inputs @supriya117