Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bazzaonline
New Contributor III

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
Esteemed Contributor

Re: Qlik Sense with 2 left joins

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
New Contributor III

Re: Qlik Sense with 2 left joins

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
Esteemed Contributor

Re: Qlik Sense with 2 left joins

How is this:

Capture.PNG

different of this?

Capture.PNG

martinpohl
Valued Contributor II

Re: Qlik Sense with 2 left joins

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