Joining Tables

[davyqliks]

Hello, I hope you can help,

I have 3 tables i need to join from 3 lookup tables.

When i dont join and load only this i get the lookup return correct:

[F1Lookup]:
LOAD

"FIBRE 1",
"f1Sustainable"
FROM [lib://Qlik01E /Object Fibre Lookup.xlsx]
(ooxml, embedded labels, table is FibreLookup);

When i join 2 tables, i only get the lookup where there is a value i in both lookups and the above result for f1sustainable = Sustainable is now blank!

[F1Lookup]:
LOAD

"FIBRE 1",
"f1Sustainable"
FROM [lib://Qlik01E /Object Fibre Lookup.xlsx]
(ooxml, embedded labels, table is FibreLookup);

[F2Lookup]:

Join([F1Lookup])
LOAD

"FIBRE 2",
"f2Sustainable"
FROM [lib://Qlik01E /Object Fibre Lookup.xlsx]
(ooxml, embedded labels, table is FibreLookup2);

See the above result is now - 

Its the same when i add a 3rd table, only get the result where there are returns from all 3 tables.

I have never tried the jon function before and any advice and help to correct would be very much appreciated.

Thank you

[PradeepK]

Please go through this link  - combine-tables-join 

For your case..

First decide what is the required Output.. and accordingly use the type of Join.

Also in your provided script, I do not see any common key to join on i.e. Field name should be exactly same;