topic LEFT JOIN not working in App Development

LEFT JOIN not working

LorenaGSaar — Mon, 28 Mar 2022 09:39:58 GMT

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

Why a simple left join doesn't works?

Thank you!

Re: LEFT JOIN not working

Or — Mon, 28 Mar 2022 13:18:23 GMT

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.