Water Cooler

iv_3021 · ‎2021-11-23

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?

stevejoyce · ‎2021-11-23

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.

stevejoyce · ‎2021-11-23

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.

Or · ‎2021-11-23

Adding to what Steve posted, it sounds like you might be looking for LEFT KEEP instead of LEFT JOIN.

Left join result and where to find it