BIND
Applies to: CELONIS 4.7
Description
BIND pulls a column to a specified table. This requires that the owner table of the column is a direct or indirect dimensional table w.r.t. the specified table.
Syntax
BIND( target_table, source_table.column)
Usage in PU functions
BIND introduces the join between the specified source table column and the target table. This can be helpful in PU functions, for example, where it enables to aggregate from the source table column to the child table in a 1:N:1 relationship:
 |
In order to aggregate from the source table to the child table, we first need to bind the source table column to the parent table using BIND. The resulting column can then be aggregated to the child table using a PU function.
If the target_table is the owner of column, column is returned unmodified.
Examples
[1] 1:n relationship between caseTable and OrderPos, 1:n relationship between productTable and OrderPos. We want to find the price of the most expensive product in an order (case). PU_MAX cannot pull directly from the productTable to the caseTable, so we use BIND to pull the price column to the OrderPos table.
|
Query