Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

Where not Exists()

Here's a script I don't quite understand:

LOAD

    .....

    PostalCode as PostCode,

    .....

Resident Customer

Where not Exists(PostCode,PostalCode);


What is the use of Where not Exists(PostCode,PostalCode)?


Thanks for help!

2 Replies
YoussefBelloum
Champion
Champion

after you understand the Exist function and in addition to the information described on the link above, you can replace your script by this:

LOAD

    .....

    PostalCode as PostCode,

    .....

Resident Customer

Where not Exists(PostCode);