topic Re: two exists conditions in QlikView

two exists conditions

santhosh_k_n — Wed, 17 Sep 2014 06:24:35 GMT

Hi all,

Is it possible to use two exists condition in single load as below,

eg:

Load A&'-'&B&'-'&C as ABC_Key,

A&'-'&B as AB_Key

from ABCD.qvd;

concatenate

Load A&'-'&B&'-'&C as ABC_Key,

A&'-'&B as AB_Key

F,G

from ABCEFG.qvd

where not exists(ABC_Key,A&'-'&B&'-'&C ) and not exists(AB_Key,A&'-'&B);

Re: two exists conditions

tresB — Wed, 17 Sep 2014 06:29:44 GMT

Possible. Do you face any issue?

Re: two exists conditions

sujeetsingh — Wed, 17 Sep 2014 06:31:53 GMT

This may help you

More than one column in Exists condition

Re: two exists conditions

santhosh_k_n — Wed, 17 Sep 2014 06:50:11 GMT

Hi tresesco,

I didnt try this as there are more than one combined keys in the table and one key is used to concatenate similar fields from other table and another one for 3rd table.

but the data when displayed is having duplicate so and thinking to use two not exists condition for two combined keys and check.