Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

simple: Load Help !

Hi,

I am blocked,

can you explain and tell me: How can I load from several sources

for 1, 2, 3 as seperated

Unbe.jpg

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

Tags (3)
3 Replies
buzzy996
Honored Contributor II

Re: simple: Load Help !

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

Re: simple: Load Help !

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

Regards,
Prashant Sangle
Not applicable

Re: simple: Load Help !

Hi,

It will work with Join operations.

Thanks,

krish

Community Browser