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....?