What is the default join type in Qlikview?

[#1]

Hi,

What is the default join type in Qlikview?

If it is an outer join how can I avoid it and enfore simple join in load script?

Thanks,

TA

[#2]

Outer join

[#3]

Thanks Andrew. How can I avoid this and enforce simple join?

[#4]

You can specify the join type that you want, eg

Inner Join (tableName)

Load fieldA, FieldB etc

Resident table2

You can also use inner, left and right.

[#5]

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

[shaktisinghchau]

By default Qlik do OUTER JOIN so records from all the tables will come whichever table does not have matching record those tables fields will come with null