load * inline [
noconcatenate load * inline [
noconcatenate load * resident tmpA
where not exists (FieldB, Field); // in tmpB
drop table tmpA, tmpB;
I have renamed the Field in the tmpB to "FieldB". QlikView does not do any relations until the end of the script, and the field "Field" is just something that sort of "floats" around. So when you say "where not exists(Field)", it checks the values in both tables, not only in the tmpB-table.
Therefore, if you rename the field in one of the tables, you will be able to specify that specific field, and check it against the other field.
Hope this helps!