two exists conditions

[santhosh_k_n]

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

         D

from ABCD.qvd;

concatenate

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

         A&'-'&B as AB_Key

         E,

         F,G

from ABCEFG.qvd

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

[tresesco]

Possible. Do you face any issue?

[sujeetsingh]

This may help you

More than one column in Exists condition

[santhosh_k_n]

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.