How to specify outer join in load script?

Mon, 10 Dec 2012 14:40:15 GMT

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,

Re: How to specify outer join in load script?

Mon, 10 Dec 2012 15:00:15 GMT

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;

topic Re: How to specify outer join in load script? in QlikView

How to specify outer join in load script?

Re: How to specify outer join in load script?