Linq query for comparing two different columns from different datatables

[Kunal_Jain]

Hi
I just need to get the linq query for two different columns of different data tables
I have provided 2 excel sheet and need the query to compare the year and date of the both the two different data tables. and compare the no first than compare the year
Invoice.xlsx (10.1 KB)
Year Sheet.xlsx (9.7 KB)
Please help me with the solution.

[Shubham_Dutta]

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