Left join not giving the desired output.

[Anady]

Hi,

I am trying to execute the below script in the QS Data Load Editor. 

I am getting the output as below, which is not what I am expecting.

Can anyone please help?

[marcus_sommer]

What is your expectation?

[hesh · Accepted solution]

@Anady  - what is the output that you are expecting?

In your script as seen from the screenshot attached the first two values i.e. A and B are being taken as column names. The rest of the values are then being considered in the Left Join and the output as displayed in the second screenshot is correct.

You may want to take a look at the below for clarity: 

Understanding Join Keep and Concatenate. 

"LEFT JOIN , also called LEFT OUTER JOIN , returns all records from the left (first) table and the matched records from the right (second) table."

so, from the script that you have attached as screenshots the output is perfectly fine.

[Anady]

@hesh  - Thank you!