topic Re: Table joins in QlikView

Table joins

Thu, 10 Dec 2015 14:59:54 GMT

Please can you help as I am new to joins within qlikview itself.

I think I need a left outer join ?

Table 1

Plant

Type

Processed Date

OrderNo

========================

Table 2

Plant

Concern

OrderNo

I want all the data from table one but ONLY the data from table TWO where the depot plant orderno match

How do I join in load ?

Re: Table joins

sunny_talwar — Thu, 10 Dec 2015 15:02:28 GMT

If you need only those rows that match from Table 2, then you need a Left Join. May be something like this:

Table1:

LOAD Plant,

Type,

[Processed Date],

Order No

FROM Source;

Left Join (Table1)

LOAD Plant,

Concern,

ID,

OrderNo

FROM AnotherSource;

Re: Table joins

Thu, 10 Dec 2015 15:19:28 GMT

Hi Sunny

I have just tried this and unfortunately I am a still getting order nos that are in

table 2 that are not in table 1.

I don't want to see these......

Re: Table joins

sunny_talwar — Thu, 10 Dec 2015 15:24:29 GMT

That cannot happen. Do you have the same casing for Plant and OrderNo (not ORDERNO and PLANT in one of the tables)?. Would be possible to share a sample which demonstrate it not working?

Re: Table joins

Thu, 10 Dec 2015 15:33:08 GMT

Attachment added - I have since changed some headings........ but you will see what I mean

For example sales order 0050607425 I would not expect to see as this does not exist in the other table.

Thanks

Re: Table joins

sunny_talwar — Thu, 10 Dec 2015 15:38:01 GMT

You still have used Outer Join in the script. Did you try Left Join as I recommended?

Re: Table joins

Thu, 10 Dec 2015 15:43:19 GMT

Hi Sunny

Sorry sent example before I save. Yes I tried your recommendation but then data drops out of the other table that I require......

Re: Table joins

sunny_talwar — Thu, 10 Dec 2015 15:45:03 GMT

Is it doing the opposite of what you wanted? Try Right Join if what I said before was true

Re: Table joins

Thu, 10 Dec 2015 15:46:26 GMT

Thanks Sunny !

Got it now - I swapped the over and it works great!

Re: Table joins

sunny_talwar — Thu, 10 Dec 2015 15:47:14 GMT

Awesome