Applies to:
| Status |
|---|
| colour | Green |
|---|
| title | Celonis 4.0 |
|---|
|
| Status |
|---|
| colour | Green |
|---|
| title | Celonis 4.2 |
|---|
|
| Status |
|---|
| colour | Green |
|---|
| title | Celonis 4.3 |
|---|
|
| Status |
|---|
| colour | Green |
|---|
| title | Celonis 4.4 |
|---|
|
Description
The Pull-Up-Functions allow you to aggregate a column based on another table. You can define the parent table to which the child-tables entries are pulled, and you can explicitly define on which basis calculations are executed.
...
| Code Block |
|---|
|
PU_X ( parent_table, child_table.column [, filter_expression] ) |
where PU_X is one of
| Code Block |
|---|
|
PU_X ( parent_table, child_table.column [, filter_expression] [, order by expression] ) |
where PU_X is one of
| Code Block |
|---|
|
PU_QUANTILE ( parent_table, child_table.column, quantile [, filter_expression] ) |
...