Why are some of my values going to [null]?

[kylershakeshaft]

I have all of the values that i need outputted, but I am getting [null] values instead of actual data in certain columns. How can i fix this?

[Emil_Kos]

Hi @kylershakeshaft,

You forgot to attach the data. The easiest way to achieve it is by using an export function and share the export:

[kylershakeshaft]

Did that work?

[apathetichell]

Your union tool is adding all entries from your right anchor which didn't match the initial join. Because those entries by definition did not have values in the left input - they do not have values in those fields when unioned in... hence - nulls. If you want no nulls you can assign them a value - or you can drop the union tool and just use the central join.

[Emil_Kos · Accepted solution]

Hi @kylershakeshaft,

If you are reffering to those columns:

you have them in one data source and you don't have them in the second one.

The data that wasn't joined:

The one from R anchor will not have this column as they didn't join correctly. Some of the data from one data set just don't show in the second one and you weren't able to join them.