Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7 

Description

Process functions perform calculations based on the Case-Id and the Activity column of the event log.

While the Case-Id column is determined by the settings in the Data Model editor, the Activity column can be chosen freely for most process functions. The Activity column can also be preprocessed with other functions. For example with REMAP_VALUES, grouping and hiding of activities can be achieved.

Grouping


[1] REMAP_VALUES groups B and C by mapping both to the same activity label.

Query
Column1
REMAP_VALUES ( "Table1".ACTIVITY , [ 'B' , 'BC' ] , [ 'C' , 'BC' ] )
Input
Table1
CASE_ID : INTACTIVITY : STRINGTIMESTAMP : DATE
1
'A'
Tue Jan 01 2019 13:00:00.000
1
'B'
Tue Jan 01 2019 13:01:00.000
1
'C'
Tue Jan 01 2019 13:02:00.000
Output
Result
Column1 : STRING
'A'
'BC'
'BC'


Hiding


[2] REMAP_VALUES hides activity B by mapping it to null.

Query
Column1
REMAP_VALUES ( "Table1".ACTIVITY , [ 'B' , NULL ] )
Input
Table1
CASE_ID : INTACTIVITY : STRINGTIMESTAMP : DATE
1
'A'
Tue Jan 01 2019 13:00:00.000
1
'B'
Tue Jan 01 2019 13:01:00.000
1
'C'
Tue Jan 01 2019 13:02:00.000
Output
Result
Column1 : STRING
'A'
null
'C'



Content

Expand all   Collapse all


  • No labels