Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
crichter14
Creator II
Creator II

For Qlik Sense - Associated Tables

When Qlik Sense associates tables in the load script, does QS treat the two tables as having an OUTER JOIN, INNER JOIN, LEFT JOIN, RIGHT JOIN?

I've been assuming Outer Join, but would like someone to verify, please.

2 Replies
nsetty
Partner - Creator II
Partner - Creator II

Default Outer join, if join with just keyword JOIN.  There is also another variation Keep when compared to SQL server joins.

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/combine-tables-join-keep...

tulabandula
Partner - Contributor III
Partner - Contributor III

Yes Qlik associates as default outer join unless we specify.