Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;