Null Operators

Use is null and is not null to check whether a value is or is not null. is null returns True when a value is null. is not null returns True when a value is not null.

This example returns rows that contain Sub_Category fields that are not null and the counts of rows that contain each field.

Use case to replace null values with a value of your choice. This example labels the null Sub-Category field “Empty.”

See Also

• filter
• group-by rollup
• group-by