
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Left join result and where to find it
Hi! I'm new to qlik sense and I have a question regarding `join` operations. Sorry in advance if my question seems strange or something.
So, having a query like this:
LEFT JOIN (table2) LOAD * RESIDENT table1;
How come I'll have the concatenated result in the table2? How does it work and why? Where can I see something on the matter in the documentation?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Join is in the qlik documenation: https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/combine-tabl...
But this is typical sql function. Only difference is Qlik joins on fields with same name(s) opposed to sql where you specify fields to join on.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Join is in the qlik documenation: https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/combine-tabl...
But this is typical sql function. Only difference is Qlik joins on fields with same name(s) opposed to sql where you specify fields to join on.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Adding to what Steve posted, it sounds like you might be looking for LEFT KEEP instead of LEFT JOIN.
