
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlik Sense with 2 left joins
Hello,
I have three sets of data all with the dimension 'Reference Number', all the files contain some reference numbers which are the same and some different ones, each with other dimensions.
I need to load the first file then left join the two other sets of data but limiting the 'Reference numbers' in the first set of data.
Example
Reference Number | Item Number |
---|---|
1 | A |
2 | B |
3 | C |
Reference Number | Part Number |
---|---|
1 | D |
2 | E |
4 | F |
Reference Number | Unit Number |
---|---|
2 | G |
3 | H |
4 | I |
Required Result
Reference Number | Item Number | Part Number | Unit Number |
---|---|---|---|
1 | A | D | |
2 | B | E | G |
3 | C | H |
Please Help

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
table1 :
load "Reference Number", "Item Number"
from source1;
left join (table1)
load "Reference Number", "Part Number"
from source2;
left join (table1)
load "Reference Number", "Unit Number"
from source3;
example:
table1:
load * Inline [
Reference Number, Item Number
1, A
2, B
3, C
];
left join(table1)
load * Inline [
Reference Number, Part Number
1, D
2, E
4 ,F
];
left join(table1)
load * Inline [
Reference Number, Unit Number
2, G
3, H
4, I
];
result:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you but it doesn't seem to work as the second left join doesn't appear to work?
Im not sure its joining to the first table?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How is this:
different of this?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Omars example is very easy but ok.
In your datas it could happen that there are more joins than you want.
Qlik is joining tables by same field names automatically, so be sure fields you want to join have same namens, you don't want different.
Regards
