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)
But how QV Know, what previous table must be checked for already exist values? (Id in this case)
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.
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
Why is 5 included, but 1 or 2 not included in your final output?
Sorry, it's my mistake:
May be like this:
Id&Field1 as Check
Where not Exists(Check, Id&Field1);
DROP Table A;
Qlik checked for this the values within the symbol-tables, see here what is meant: Symbol Tables and Bit-Stuffed Pointers.
Where not Exists(Id);
Maybe like this?
Load * Inline [
Where Not Exists (Id);
Drop Table temp1;
Retrieving data ...