[en] Null Handling

[en] Below is a table that demonstrates how Alteryx Designer handles Nulls as of version 5.0 and later. The same handling applies to numbers and strings.

[en] If a number is added to Null, the result is Null.

[en] 1 + Null() == Null()

[en] If a String is added to Null, the result is the String.

[en] [ABC123] + Null() == ABC123

[en] Nothing is greater or less than Null(). If there is a Null() on either side of a < (less than) or > (greater than), the answer is False.

[en] Null() < Null() == False

[en] When using <= (less than or equal) or >= (greater than or equal), if there is a Null() on either side, the only way the comparison equals True is if there is a Null() on the other side because Null() == Null().