Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to specify outer join in load script?

Hi,

Suppose I have 3 tables called:

Table 1 (consists of last 1 weeks data - least data)

Table 2 (consists of last 4 weeks data - less data)

Table 3 (consists of last 52 weeks data complete data)

currently in my load statement Table 1 is written on first place and Table 3 on the last place

How can I find out the outer join criteria in my Qlikview file?

I mean which table is create outer join on which table?

In fact I want to create an outer join for Table 3 (consists of last 52 weeks data complete data) on Table 2 (consists of last 4 weeks data - less data) and Table 1 (consists of last 1 weeks data - least data)?

Can some one write the load statement with outer joins?

Thanks,

TA

1 Reply
Not applicable
Author

if you want to join table 1 and 2 to table 3 then do this...

Table3:

load * from table;

Table1:

outer join(Table3)

load * from Table1;

Table2:

outer join(Table3)

load * from Table2;