Linq query for comparing two different columns from different datatables

Help Studio
, ,
2

Hi @Kunal_Jain ,
You can try this code, drag invoke code activity select language as C#

DT2.AsEnumerable().ToList().ForEach(m=>{
DT1.AsEnumerable().Where(r=> m.Field<String>("ID")==r.Field<String>("EmpID")).ToList().ForEach(s=>{
	s.SetField<String>("EmpName",m.Field<String>("Name"));
	s.SetField<String>("EmpRole",m.Field<String>("Role"));
});

});

DT2- Invoice excel datatable
DT1- Year Sheet datatable

And you can change the column names in the code as per your wish.

Thanks & Regards,
Shubham Dutta