Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

alexandermllr
Contributor

Qlikview - Where not by ID

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

IDaction
123action 1
123action 2
123action 3
456action 2
456action 5

 

Result:

IDaction
456action 2
456action 5

 

Thank for the help!

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Qlikview - Where not by ID

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;

 


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Qlikview - Where not by ID

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;

 


talk is cheap, supply exceeds demand
Highlighted
alexandermllr
Contributor

Re: Qlikview - Where not by ID

Thank you very much! 🙂