Discussion Board for collaboration on QlikView Scripting.
Colleagues, good day!
Script loads first table:
Then i must load second table but only data for those Id which are not contain in first table:
In result i must get only:
Try on your second load :
where not exists (Id)
May be like this:
Where not Exists(Id);
DROP Table A;
But how QV Know, what previous table must be checked for already exist values? (Id in this case)
Maybe like this?
Load * Inline [
Where Not Exists (Id);
Drop Table temp1;
QlikView checks the data model for the field Id and looks up values already loaded into the field. This is done at the field level, not the table level.
This is how Exist function works where it checks against all possible value within a field previously loaded in the script.
Qlik checked for this the values within the symbol-tables, see here what is meant: Symbol Tables and Bit-Stuffed Pointers.
And is is possible to check for some fields combinations?
for where not Exists(Id&F1) i must get only:
but it returns empty result