Hi Guys,

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 rSheet1$$] 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