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.Field(Of String)(“Item”) _
Then loop over the results to add/build the joined table.
Is this possible within UiPath? I have tried several ways but always seem to hit type errors at the loop. Am I missing some other way to do this?