exists

[srihitha]

I am expecting citizens table should have only value 'Bill' in Employee field.

But , it has all employees in Citizens table even after using where Exists (Employee,'Bill');

Can someone  please explain ?

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,'Bill');

[vikasmahajan]

https://community.qlik.com/t5/QlikView-App-Dev/UnderStanding-Where-Exists/td-p/1398587

you can use following:

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

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

[rwunderlich]

Exists() expects fieldnames, not literals. If you want to Citizens to just 'Bill', what you want is :

where Employee = 'Bill'