How to Join Datatable via Code

[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