Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
AxelZ
Contributor II
Contributor II

Limited amount of Outer Join by Qlik Sense?

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

 

Labels (2)
1 Reply
ajaykakkar93
Specialist III
Specialist III

Hi,

Please create a composite key for the join to work properly, Add only those columns which are necessary as reloading & join will be applied accordingly.

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting