Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4
Description
CASE WHEN
evaluates a list of conditions and returns result expressions based on these conditions.
A CASE WHEN
statement consists of one or more conditions with associated result expressions.
Syntax
CASE WHEN condition THEN result_expression [ WHEN condition THEN result_expression ]* ELSE result_expression END
The result expression of the first condition that evaluates to true is returned. If no condition holds, the expression in the ELSE
part is returned. If a condition cannot be evaluated because an input column is NULL, NULL is returned.
All result expressions must be of the same type. The result type of the CASE WHEN statement is equal to the type of the result expressions.
Examples
CASE WHEN with one condition:
Column1
CASE WHEN "Table1"."Column1" = 1 THEN 2 ELSE 5 END
Use CASE WHEN to replace NULL values with 0.
Column1
CASE WHEN ( ISNULL("Table1"."Column1") = 1 ) THEN 0 ELSE "Table1"."Column1" END
Return 'even' if the input value is even, and 'odd' otherwise. NULL input values result in NULL output values:
Column1
CASE WHEN MODULO("Table1"."Column1", 2) = 0 THEN 'even' ELSE 'odd' END