Data flow
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
Description
This section contains data flow operators.
The following functions are available:
CASE WHEN evaluates a list of conditions and returns result expressions based on these conditions.
COALESCE returns the first input value which is not NULL of a set of values.
FILTER can be defined as Analysis filters, Sheet filters or Component filters and are applied to the input tables before the actual query.
REMAP_VALUES can be used to map values of a column to other values.