topic Re: Joining Tables Question in QlikView

Joining Tables Question

mccook — Fri, 14 Feb 2014 12:49:14 GMT

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

Re: Joining Tables Question

maxgro — Fri, 14 Feb 2014 12:50:45 GMT

join without left

Re: Joining Tables Question

luis_pimentel — Fri, 14 Feb 2014 12:51:58 GMT

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.

Re: Joining Tables Question

hic — Fri, 14 Feb 2014 12:52:13 GMT

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

Re: Joining Tables Question

Fri, 14 Feb 2014 12:52:24 GMT

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