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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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;