topic Exists Clause in Where in App Development

Exists Clause in Where

guruprem — Wed, 18 Mar 2020 12:03:13 GMT

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

Re: Exists Clause in Where

tresB — Wed, 18 Mar 2020 12:32:40 GMT

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

Re: Exists Clause in Where

sunny_talwar — Wed, 18 Mar 2020 12:35:47 GMT

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