How to join specific column from another datatble and merge into another datatble based on identity column using linq query in real time

Aravinthan · June 19, 2019, 10:13am

AshwinS2 · June 19, 2019, 10:21am

Hi @Aravinthan
Check both datatable where row(“colA”).equals row(“col A”) add data row of dt 2
Try to use invoke method as merge

Merge dt1 and dt2

Thanks
Ashwin.S

Aravinthan · June 19, 2019, 10:23am

we can merge based on column conditions bro

AshwinS2 · June 19, 2019, 10:26am

Yes you can create a build datatable for dt2 and add column name as proj
Add data row and use invoke method

Thanks
Ashwin.S

Topic		Replies	Views
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 Help activities	10	5392	January 22, 2020
How to join two datatable all columns based on join conditions using linq query Help datatable , activities	0	1420	June 27, 2019
Linq For 2 datatables. Inserting datat from one datatable to another using one common column Studio studio , question , workflow_diff	37	1303	August 21, 2023
Merge rows in a data table Activities datatable , uiautomation , activities , question	7	991	July 10, 2023
LINQ to Add Column from one DataTable to Another Studio	5	636	January 10, 2024