Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 


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.

Syntax

ISNULL ( table.column )

Examples


Return the result of the ISNULL operator for a STRING column and use it inside a CASE WHEN condition:
Query
Column1
ISNULL ( "Table1"."Country" )
Column2
CASE WHEN ( ISNULL ( "Table1"."Country" ) = 1 ) THEN '-' ELSE "Table1"."Country" END
Input
Table1
Country : STRING
'US'
'DE'
null
'IT'
'DE'
null
'FR'
Output
Result
Column1 : INTColumn2 : STRING
0
'US'
0
'DE'
1
'-'
0
'IT'
0
'DE'
1
'-'
0
'FR'



Return the result of the ISNULL operator for a INT column and use it inside a CASE WHEN condition:
Query
Column1
ISNULL ( "Table1"."IntColumn" )
Column2
CASE WHEN ( ISNULL ( "Table1"."IntColumn" ) = 1 ) THEN 0 ELSE "Table1"."IntColumn" END
Input
Table1
IntColumn : INT
1
0
10
13
null
null
-5
Output
Result
Column1 : INTColumn2 : INT
0
1
0
0
0
10
0
13
1
0
1
0
0
-5



See also:

  • No labels