How do I do this in Qlikview?
How do I write a query (using Resident as both tables are already read) in the script that results in:
as x3 is the only value that only exists in Table A
Hi, first you would need to load Itemno and itemno as itemnocheck in your table B load, then you can load using where not exists ie:
resident table a_ where not exists(itemnocheck);
Maybe like this, adding to your script with existing tables:
LOAD ItemNo as ExcludeItemNo Resident TableB;
LOAD ItemNo as OnlyInTableAItemNo Resident TableA where not exists(ExcludeItemNo, ItemNo);
drop table TMP;
Retrieving data ...