Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Do you know if Qlik Sense only allows a limited amount of Outer Join you can do to create one table?
My script looks like this:
Final:
LOAD * FROM Table1;
Outer Join Final
LOAD * FROM Table2;
OUTER Join Final
LOAD * Resident temp1;
OUTER Join Final
LOAD * FROM Table3;
OUTER Join Final
LOAD * FROM Table4;
The script runs fine and my table is created but it looks like the links with the last table are not made properly.
If I move the outer join with the Table4 before the outer join with the Table3, the Table3 is causing problems. I'm wondering then if Qlik limits the amount of Outer Join we can do for the creation of one table...
Thanks for your help!
Axel