topic Re: What is the default join type in Qlikview? in QlikView

What is the default join type in Qlikview?

Fri, 07 Dec 2012 15:50:13 GMT

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,

Re: What is the default join type in Qlikview?

Fri, 07 Dec 2012 15:52:17 GMT

Outer join

Re: What is the default join type in Qlikview?

Fri, 07 Dec 2012 15:54:06 GMT

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

Re: What is the default join type in Qlikview?

Fri, 07 Dec 2012 15:56:59 GMT

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.

Re: What is the default join type in Qlikview?

Mon, 10 Dec 2012 14:37:34 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: What is the default join type in Qlikview?

shaktisinghchau — Tue, 23 Oct 2018 14:30:12 GMT

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