Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;