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

ColA ColB ColC ColA Proj
Aravind Pondy Test Ram 25
Ram Chennai Songs Aravind 35
Shan delhi Play
ColA ColB ColC Proj
Aravind Pondy Test 35
Ram Chennai Songs 25

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


we can merge based on column conditions bro

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