DOMAIN_TABLE
Applies to: CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
The DOMAIN_TABLE function can be used to create a temporary table from various column(s), which can be used as a child table inside all PU functions.
It is not possible to use the same table as the parent and the child table in a PU function. However, the DOMAIN_TABLE function can be used to create a temporary table from various column(s). These column(s) must have a common parent table to which the columns are joined to. The column for the PU function has to be from a common parent table of the specified column(s) for the temporary table. Further documentation about parent and child tables can be found in Join functionality.
The temporary table created by DOMAIN_TABLE contains all unique combinations of values from the specified column(s) existing in the result of joining these column(s) to their closest common parent table. The resulting temporary table is a child table of the closest common parent table of the specified column(s).
Syntax
DOMAIN_TABLE ( table.column, ... )
Examples
[1] For each case ID, calculate the number of times the associated company code is contained in the table using |
[2] Filter on all cases where the associated company code occurs less than three times in the table.
|
[3] In this example, the activity table is filtered on all entries that happened on a day with more than three actvities. For this, the
|