Compare two excels(file a and file b) after updating status on file a column

HI all

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…

any ideas please…

Regards & thanks

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

2 Likes

k i will look into it…

hi team,
can you help me with this… @Karthick_Settu

assessment.xaml (14.4 KB)

thanks

Kindly check this file.
assessment.xaml (15.8 KB)

2 Likes

Thanks @Karthick_Settu:v::v::v:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.