my scenario is in excel file a have column id as 1,2,3,4 and salary as 1000,2000,3000,4000 .
and excel file b column is id 1,2,3,4 and salary 1000,2000,4000,5000. and then output will updated on status column in file a…
read Excel1 and save in Datatable1 variable
read Excel2 and save in Datatable2 variable
then use this query in if condition .
(From x in Datatable1.AsEnumerable()
where (From y in Datatable2.AsEnumerable()
where convert.tostring(x(“ID”)).trim.tolower.equals(convert.tostring(y(“ID”)).trim.tolower) and convert.tostring(x(“Salary”)).trim.tolower.equals(convert.tostring(y(“Salary”)).trim.tolower) ).count>0
Select x).count>0
You will get a Bool Value u can determine if the value exists or no