Join including null values

[mzp]

Hi Everyone,

I am looking for a solution on how to include null values when joining two data sets. One of my inputs is a template and I would like to keep it as it is including the nulls. Thanks!!!

[Thableaus]

Hi @mzp 

We'd need a sample of your data and understand how your workflow and your join is set up.

Cheers,

[AlteryxUserFL]

You may want to consider the append tool. Without seeing your data, I can't be sure, but I think you are looking to append data, not join it.  

[bharatandalam]

Hi @mzp,

Simplest way to do that is change the null value to a string like NVL(field, 'Unknown'), then you can include the null   values. 

[jrgo · Accepted solution]

@mzp 

This would work if I understood the need correctly. If you need to keep the NULLs from the Right input, or both, move, or add another, filter to the right output and connect into the Union.

Hope this helps!

Jimmy
Teknion Data Solutions

[mzp]

This is exactly what I needed! thanks you! :)