I have an excel where for some records status column says 'Matched' and for other records the status column is blank.
I tried the excel advanced package loop commands & inside loop for each row in excel advanced sheet I am putting an if cond. like below :
if(Status not equal to 'Matched') then log to file those records for which this if condition satisfies.
Instead, it is logging all the records irrespective of the if condition. I tried the same using excel as DB queries (select * from [Sheet1$$] where Status<>'Matched') still it is giving the same results.
Please correct me if I am ignoring any other logic.
Thanks in advanced for any help/suggestion