topic Re: simple: Load Help ! in QlikView

simple: Load Help !

Mon, 16 Mar 2015 10:57:29 GMT

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 — Mon, 16 Mar 2015 11:21:48 GMT

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

PrashantSangle — Mon, 16 Mar 2015 11:32:36 GMT

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

Mon, 16 Mar 2015 11:37:23 GMT

Hi,

It will work with Join operations.

Thanks,

krish