Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am blocked,
can you explain and tell me: How can I load from several sources
for 1, 2, 3 as seperated
T1:
Load Key1 without Key3 as K1
FROM SQL...S1
T2:
Load Key1 where match Key3 with last (versionnr) as K2
T3:
Load Key3 without Key1 as K3
Have I to join the keys, which are from different sources? K1 from S1, K3 from S3
u have to try to play with joins accordingly ur keys.
Hi,
Play with below code you have to use Exists() and not Exists()
T1:
Load Key1as K1
FROM SQL...S1
where not exists(Key3,Key1);
T2:
Load Key1 where match Key3 with last (versionnr) as K2
where exists(Key3,Key1)
T3:
Load Key3 without Key1 as K3
where not exists(Key1,Key3)
Regards
Hi,
It will work with Join operations.
Thanks,
krish