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?