Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
Possible. Do you face any issue?
This may help you
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.