Qlik Sense with 2 left joins

[bazzaonline]

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

[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:

[bazzaonline]

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:

different of this?

[martinpohl]

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