Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

Pull Up aggregation - Table options

Applies to: CELONIS 4.5 CELONIS 4.6 CELONIS 4.7

Description

Besides using a table from the data model as a child table inside a PU function, generated tables can be passed.

In the first argument of every PU function, a child table needs to be specified, which is the table to which the aggregated values are pulled. This child table can be a table from the data model, or it can be one of the following two special table options:

  • CONSTANT: Aggregates all values of a column to one single value, without any grouping.

  • DOMAIN_TABLE: Creates a temporary table from various column(s). For example, this can be used if values of a column should be aggregated based on a column of the same table.