Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator

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 NumberItem Number
1A
2B
3C

Reference NumberPart Number
1D
2E
4F

Reference NumberUnit Number
2G
3H
4I

Required Result

Reference NumberItem NumberPart NumberUnit Number
1AD
2BEG
3CH

Please Help

4 Replies
OmarBenSalem

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:

Capture.PNG

bazzaonline
Creator
Creator
Author

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?

OmarBenSalem

How is this:

Capture.PNG

different of this?

Capture.PNG

martinpohl
Partner - Master
Partner - Master

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