Description

Celonis represents unknown or non-existing values as NULL. It is important to mention that it is not a data type of its own, but it can be used in all columns independent from the data type. In order to check the exact NULL behavior of certain operators, please refer to their documentation.

Typical NULL behavior

• Aggregations usually ignore NULL values.
• Calculations usually return NULL if the input value is NULL.
• If there are for a certain group/case only NULL values, the result is usually NULL.

Tips

• If NULL values are unwanted, ISNULL or IS NULL can be used to filter them out.
• With CASE WHEN or REMAP_VALUES unwanted values can be explicitly set to NULL in order to be ignored for certain calculations.