Applies to:
| Status | ||||
|---|---|---|---|---|
|
| Status | ||||
|---|---|---|---|---|
|
| Status | ||||
|---|---|---|---|---|
|
| Status | ||||
|---|---|---|---|---|
|
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, for most process functions, freely chosen. The Activity column can also be pre-processed with other functions.
Grouping
Example
REMAP_VALUES groups B and C by mapping both to the same activity label.| title | Query |
|---|
Column1
| Code Block | ||||
|---|---|---|---|---|
| ||||
REMAP_VALUES("Table1".ACTIVITY, ['B', 'BC'], ['C', 'BC']) |
| title | Input |
|---|
Table1
1
Sun Jan 01 2017 13:00:00.000
1
Sun Jan 01 2017 13:01:00.000
1
Sun Jan 01 2017 13:02:00.000
| title | Output |
|---|
Result
Hiding
Example
REMAP_VALUES hides activity B by mapping it to null.| title | Query |
|---|
Column1
| Code Block | ||||
|---|---|---|---|---|
| ||||
REMAP_VALUES("Table1".ACTIVITY, ['B', NULL]) |
| title | Input |
|---|
Table1
1
Sun Jan 01 2017 13:00:00.000
1
Sun Jan 01 2017 13:01:00.000
1
Sun Jan 01 2017 13:02:00.000
| title | Output |
|---|