where not Exists

[RK01923683]

Dear Experts,

Can anyone please explain with example, how i can use where not exist statement in qlik.

I know how we use that statement in SQL.

But i am confuse with qlik.

Thanks in Advance😊

[danilostochi]

//look

Employees:
LOAD * inline [
Employee|ID|Salary
Bill|001|20000
John|002|30000
Steve|003|35000
] (delimiter is '|');

Citizens:
Load * inline [
Employee|Address
Bill|New York
Mary|London
Steve|Chicago
Lucy|Madrid
Lucy|Paris
John|Miami
] (delimiter is '|') where Exists (Employee);

Drop Tables Employees;