Joining Tables Question

[mccook]

Hi,

I have 2 tables like below:

Table 1

Name	Column 1	Column 2	Column 3
John	X	X	X
Dean			X
Lisa	X	X

Table 2

Name	Column 4	Column 5	Column 6
Mary	X		X
Lisa		X
Dean	X	X

What I need to do is Join the tables to get below:

Table 3

Name	Column 1	Column 2	Column 3	Column 4	Column 5	Column 6
John	X	X	X
Dean			X	X	X
Lisa	X	X			X
Mary				X		X

I've being trying to do a left join on "Name" from table 1 and then table 2 (then I lose Mary, as she doesn't exist in table 1) and then unsuccessfully trying a Concatenate for any names that don't already exist (to get Mary back).

Is there another type of join that I'm missing, please help?

Cheers,

Dean

[maxgro]

join without left

[luis_pimentel · Accepted solution]

There are 4 types of Join: Left, Right, Outer and Inner

What you need in your example is a Outer Join (or just "Join").

Take a look to the qlikview help.

-Luis.

[hic]

First of all - you don't need to join the two tables to be able to get a view like you want . Just load the tables and create a straight table or table box.

Should you still want to join, you should do an outer join, i.e.

Load * From A;

Join

Load * From B;

HIC

[#5]

Use JOIN or OUTER JOIN if you really have to join them instead of relying on QV associative model which does the same by default