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: 
guruprem
Partner - Creator III
Partner - Creator III

Exists Clause in Where

Hi,

These I found Exists clause is not working as per my understanding kindly advise.

1) LOAD * FROM xyz.QVD(qvd) Where Exists(COMP_CODE, 'ABC') is giving zero records. 

2) LOAD * FROM xyz.QVD(qvd) Where COMP_CODE='ABC' is giving very many records.

Best Regards

Guruprem

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Your above two statements are not going to produce same results.

 LOAD * FROM xyz.QVD(qvd) Where Exists(COMP_CODE, 'ABC')  - this statement would cause to:

   load COMP_CODE  'ABC' if that is already loaded (and exists) earlier. I would not go and explain more here, but ask you to check it here :Exists() in Qlik 

 

View solution in original post

2 Replies
tresesco
MVP
MVP

Your above two statements are not going to produce same results.

 LOAD * FROM xyz.QVD(qvd) Where Exists(COMP_CODE, 'ABC')  - this statement would cause to:

   load COMP_CODE  'ABC' if that is already loaded (and exists) earlier. I would not go and explain more here, but ask you to check it here :Exists() in Qlik 

 

sunny_talwar

What exactly are you trying to do here? A brief introduction will help us point you in the right direction.