How to merge DataTables but combine rows if ID matches uipath

[KarthikByggari]

If your studio is below the version ,

check this thread -

Join Two DataTables

Trevor Napier June 27, 2016 21:44 NONE So I know going through VB/C# you can use LINQ to join two tables IE Dim query = From tl1 In InputTableOne.AsEnumerable() _ Join tl2 In InputTableTwo.AsEnumerable() _ On tl1.Field(Of Integer)(“Customer_ID”) Equals _ tl2.Field(Of Integer)(“Customer_ID”) _ Select New With _ { _ .ID = tl1.Field(Of Integer)(“Customer_ID”), _ .Customer_Name = tl1.Field(Of String)(“Customer_Name”), _ .Order_ID = tl2.Field(Of Integer)(“Order_ID”), _ .Order_Item = tl2.…