Skip to main content

Celonis Product Documentation

Data Flow

Description

This section contains data flow operators.

The following functions are available:

  • BIND pulls a column to a specified table.

  • BIND_FILTERS pulls a filter to a specified table.

  • 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.

  • FILTER_TO_NULL propagates the FILTER to the specified column by setting all violating rows to NULL.

  • GREATEST returns the greatest element that is not NULL from a set of values.

  • LEAST returns the least element that is not NULL from a set of values.

  • LOOKUP returns values retrieved from a different table for which no join path exists in the data model.

  • MULTI CASE WHEN returns a new column containing all THEN values for which the respective WHEN conditions evaluated to true.

  • REMAP_VALUES and REMAP_INTS can be used to map values of a column to other values.

  • UNIQUE_ID returns a unique non-negative INT for each unique tuple in the combination of the input columns.