Load Order

[Anonymous]

Hi I want to know how best to deal with load order wherein I am carrying out joins to a main table then using the resultant table to carry out another join, then using the resultant table of that to carry out the next join and so on. So for instance I have the following:

A:

LOAD * FROM TABLE A

LEFT JOIN (A)

LOAD * RESULTANT TABLE

LEFT JOIN (RESULTANT TABLE )

LOAD * NEXT RESULTANT TABLE

LEFT JOIN ( NEXT RESULTANT TABLE )

Please let me know in case it doesnt make sense but essentially carrying out join to a table then using the result of that to carry out the next join and so on ...

[isingh30]

Your requirement is not clear. Why we are joining these tables?

Thanks.

[MK_QSL]

1) Qlik Data Model works based on ASSOCIATIONS.. so you don't have to join all table to create a single table DM

2) If you still wants to join then

T1:
Load * Table1;

Left Join(T1)

Load * Table2

Left Join (T1)

Load * Table3

is the right way as per my view.

But I strongly believe that it will also depends on

one to one

one to many

many to one

many to many

relationship between field values.

[Anonymous]

Ok just to be clearer this is what I'm trying to do.

I have one main table and then a separate exceptions list both of which contain the field 'Contract_ID. What I'm trying to do is effectively say if the contract ID is not on the exceptions list ie it doesnt match on Contract_ID then lookup these Contract IDs to a further mapping.

Likewise if they do match then again map to a separate mapping.