topic Re: Condition clause while writing where not exist condition in QlikView

Condition clause while writing where not exist condition

ak00428233 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have gone through Exists and not exists condition.Could you please guide me regarding the condition.

Employees:

LOAD * inline [

Employee|ID|Salary

Bill|001|20000

John|002|30000

Steve|003|35000

] (delimiter is '|');

Citizens:

Load * inline [

Name|Address|ID

Bill|New York|001

Mary|London|004

Steve|Chicago|003

Lucy|Paris|005

John|Miami|002

] (delimiter is '|');

EmployeeAddresses:

Load Name as Employee, Address Resident Citizens where not Exists (Employee, Name);

In the above expression the condition was used between (Employee,Name).But could any suggest me to use this condition for ID also in the same table EmployeeAddresses.

Thanks in advance

Regards,

Anu

Re: Condition clause while writing where not exist condition

YoussefBelloum — Wed, 07 Mar 2018 10:25:54 GMT

Hi,

try this:

EmployeeAddresses:

Load Name as Employee,

Address,

Resident Citizens

where not Exists (Employee, Name) and not exists(ID);

Re: Condition clause while writing where not exist condition

ak00428233 — Wed, 07 Mar 2018 15:21:12 GMT

Thank you youssef. It is working fine now.

Re: Condition clause while writing where not exist condition

YoussefBelloum — Wed, 07 Mar 2018 15:25:57 GMT

You're welcome.

Good luck

Re: Condition clause while writing where not exist condition

ak00428233 — Wed, 07 Mar 2018 15:34:22 GMT

Thank you youssef.