Discussion Board for collaboration related to QlikView Deployment.
Hi I have incremental reload with where not exists syntax.
But I am getting only one record for the history.
I have been doing WHERE NOT EXISTS for many times, this is the first time I've seen this.
WHERE NOT EXISTS (PRCS_DTE)
Go to Solution.
That's because the symbol table will be updated as soon as the first record with a new PRCS_DTE value is loaded in (i.e. it is updated during the LOAD, not at the end of the statement).
Hence WHERE NOT EXISTS returns false for any following record with the same value.
PRCS_DTE as PRCS_TODAY
WHERE NOT EXISTS (PRCS_TODAY, PRCS_DTE);
DROP FIELD PRCS_TODAY;
Thank you Stefan, what does "symbol table" mean?
That's where the distinct field values are stored:
Symbol Tables and Bit-Stuffed Pointers
Thank you very much! Tremendously helpful!
I had a similar issue as Jessica today and I could adapt your solution to work for me.
Thank you, very much appreciated.