Skip to main content
Navigator | Tier 3
September 11, 2022
Question

Extract excel rows using excel advanced package

  • September 11, 2022
  • 2 replies
  • 105 views

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 [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

    2 replies

    Navigator | Tier 3
    September 12, 2022

    change the condition to be not include may be it have space

    Ashwin A.K
    Navigator | Tier 3
    September 12, 2022

    Hi @Abhishek Mishra​ ,

     

    Could you try using the inline operation :String.trim and uncheck the box for Match Case?

     

    image 

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com