Table joins

[#1]

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

ID

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 ?

[sunny_talwar]

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;

[#3]

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......

[sunny_talwar]

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?

[#5]

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

[sunny_talwar · Accepted solution]

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

[#7]

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......

[sunny_talwar]

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

[#9]

Thanks Sunny !

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

[sunny_talwar]

Awesome