Null Handling
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.
Data 1 | Data 2 | Data1 > Data2 | Data1 < Data2 | Data1 == Data2 | Data1 != Data2 |
|---|---|---|---|---|---|
1 | [Null] | False | False | False | True |
0 | [Null] | False | False | False | True |
[Null] | [Null] | False | False | True | False |
If a number is added to Null, the result is Null.
1 + Null() == Null()
If a String is added to Null, the result is the String.
[ABC123] + Null() == ABC123
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.
Null() < Null() == False
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().