Left outer join missing values

[HugoDataAve2023]

I am using a left outer join to match two tables according a index. I need the nonmatched from the first, to calculate some rate. The problem is that, when I expand, the rows that should come with null values just disappear. This wrong in a lot of sense, since will become a inner join. 

Before expand

After expand:

Where is zero????????

This is so wrong. I will miss a entire work when if I don't fix that.

[HugoDataAve2023 · Accepted solution]

I find the problem, the null observation was there, but I didnt uploaded all rows. My bad.