How to Join Datatable via Code

[mayuyu (Near)]

Hi,

I know that there is an existing join activity, but in a situation where i want to perform a datatable join via code (linq) in UiPath how do i do this given that Uipath disallows Anonymous typing by default?

[sureshj (suresh_hserus)]

@mayuyu

Refer This,

How to join two datatables using LINQ with identity column and it should select only specific columns from both datatable and it should not null value to merge while we match identity column

[T1] while joining two tables with identity column username it should allow null values as shown in output screenshot

Join Two DataTables

Hello Samir!! Thanks for your solution. I need to ask how to join 2 different sheets of Single Excel Workbook into single excel sheet. I want to merge two excel sheet into one sheet. I have excel workbook SampleClientsData.xlsx. It contains 2 different sheets first is “Client_Members_Sheet” and another is “Sales_Member_Sheet”. I want to get Sales_Member_Sheet data into Clients_Members_Sheet without blank columns and proper data. I tried using Merge Datatable. But it is not working. It is adding …

Thanks,
Suresh J

[Abisha (Abisha gopalan)]

Hi,

you can use below code

tempDt = (From x In dt1 Join y In dt2 On x(“id”).toString Equals y(“pkgId”).toString
Select tempDt.LoadDataRow(New Object(){x(“id”).toString,x(“name”).toString,y(“Location”).toString,y(“Country”).toString},False)).CopyToDatatable

[mayuyu (Near)]

Big thanks to you guys!