This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!
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?
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.
View solution in original post
Adding to what Steve posted, it sounds like you might be looking for LEFT KEEP instead of LEFT JOIN.