topic Qlikview - Where not by ID in QlikView

Qlikview - Where not by ID

alexandermllr — Thu, 21 Mar 2019 15:18:55 GMT

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

Result:

Thank for the help!

Gysbert_Wassenaar — Thu, 21 Mar 2019 16:21:54 GMT

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 — Fri, 22 Mar 2019 07:37:07 GMT

Thank you very much! 🙂