Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
LorenaGSaar
Contributor II
Contributor II

LEFT JOIN not working

Hello,

I have a very simple question.

I want to join two tables, where Table A I have my numerical data, and B I have the same dimensions plus another column.

Using a simple left join it is not working, the Column Factorized_Units results in 0.

I'm doing a very simple command such as:

Final:

LOAD * FROM

Table A

Left Join

LOAD * FROM

Table B

LorenaGSaar_0-1648460377587.png

 

Why a simple left join doesn't works?

Thank you!

Labels (1)
1 Reply
Or
MVP
MVP

Pretty hard to say since all you've included is a list of columns...

I'd suggest checking:

1) Data types match for each key field between the two tables. If they do not, they should be made to match

2) Values in B match to a value in A for all of the key fields

Something you could try is to remove the LEFT JOIN and just load the two tables individually. Then, select a value in the Factorized_Units field and see which other fields gray out entirely (all values are excluded) when they shouldn't.