Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
roy_fredericks
Contributor
Contributor

Load Order

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 ...

3 Replies
isingh30
Specialist
Specialist

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

Thanks.

MK_QSL
MVP
MVP

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.

roy_fredericks
Contributor
Contributor
Author

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.