Qlikview - Where not by ID

[alexandermllr]

Hello,

I want to join a table, but when the field action is "action 1" it should not join, but also not all other lines in the ID

ID	action
123	action 1
123	action 2
123	action 3
456	action 2
456	action 5

Result:

ID	action
456	action 2
456	action 5

Thank for the help!

[Gysbert_Wassenaar · Accepted solution]

tmp:
LOAD ID FROM ...source... WHERE action = 'action1';

IDs:
LOAD ID FROM ...source.. WHERE Not Exists(ID);

DROP TABLE tmp;

data:
LOAD ID, action WHERE Exists(ID);

DROP TABLE IDs;

[alexandermllr]

Thank you very much! 🙂