0 Replies Latest reply: Sep 30, 2015 9:45 AM by Ruud Cruchten RSS

    Where multiple clauses

    Ruud Cruchten

      Hi

       

      I'm optimizing my script and the following doesn't anymore:

      LOAD

      ...

      FROM

      $(vstoresource)XXXXXXXXXXXX.xlsx

      (ooxml, embedded labels, table is XXX)

      where wildmatch([Derde nummer opdracht], '130044', '80004', '190089') and not Exists(Opdracht) ;

       

      What I did before was creating a QVD with a where wildmatch([Derde nummer opdracht], '130044', '80004', '190089') clause,

      then load that qvd again with a where not Exists(Opdracht) ; clause.

       

      Seemed to me that this could be done without creating a QVD first but Qlikview keeps loading 0 records....

       

      What should the correct syntax be for where .... and not exist....?