simple: Load Help !

[#1]

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

[buzzy996]

u have to try to play with joins accordingly ur keys.

[PrashantSangle]

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

[#4]

Hi,

It will work with Join operations.

Thanks,

krish