Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

Process

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

Output

Table1

CASE_ID : INT

ACTIVITY : STRING

TIMESTAMP : 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

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

Output

Table1

CASE_ID : INT

ACTIVITY : STRING

TIMESTAMP : 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

Result

Column1 : STRING

'A'

null

'C'