Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5
Description
The ISNULL function returns an INT which indicates whether the input value is NULL. If the input value is NULL, 1 is returned, and 0 otherwise.
ISNULL can be applied to any data type.
Typically, ISNULL is used inside a condition, for example in a CASE WHEN or FILTER statement. In order to map NULL values to a different value, COALESCE or REMAP_VALUES can also be used instead of a CASE WHEN combined with ISNULL.
Syntax
ISNULL ( table.column )
Examples
Query
Column1
ISNULL ( "Table1"."Country" )
Column2
CASE WHEN ( ISNULL ( "Table1"."Country" ) = 1 ) THEN '-' ELSE "Table1"."Country" END
Query
Column1
ISNULL ( "Table1"."IntColumn" )
Column2
CASE WHEN ( ISNULL ( "Table1"."IntColumn" ) = 1 ) THEN 0 ELSE "Table1"."IntColumn" END