How to merge DataTables but combine rows if ID matches uipath

[Ranjith1996 (Ranjith Ratnala)]

Please help me with this.
Thanks

[KarthikByggari]

Join Data Tables

[Ranjith1996 (Ranjith Ratnala)]

HIi Karthik,
There is no join wizard in my uipath version.

[balupad14 (Balamurugan)]

Hi @Ranjith1996,

The JoinTables has been released in Version of 18.3.1 . you can able to see the release notes in the below link. Make sure that you have the same version or higher.

https://www.uipath.com/product/release-notes/uipath-v2018.3.1

Regards
Balamurugan.S

[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.…