Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
join without left
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.
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
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