Skip to main content

Celonis Product Documentation

NULL

Description

Celonis represents unknown values or values that don't exist as NULL. Remember that NULL is not a data type of its own, but it can be used in any column, independent from the data type. In order to check the exact NULL behavior of an operator, please refer to its documentation.

Typical NULL behavior
  • Aggregations usually ignore NULL values.

  • Calculations usually return NULL if the input value is NULL.

  • If a group/case has only NULL values, the result is usually NULL.

Tips
  • You can use the ISNULL or IS NULL functions to filter out NULL values.

  • You can use CASE WHEN or REMAP_VALUES to explicitly set values to NULL. You would typically do this when you want them to be ignored in calculations.