Skip to main content

PQL46 (PQL Function Library - CPM 4.6)

PROCESS_ORDER

Applies to: CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6

Description

PROCESS_ORDER returns the position of each activity within a case. Only not null activities are counted.

Syntax
PROCESS_ORDER ( table.column )

  • column: Column which has to be joinable to the activity table

Examples

[1] Example with two cases in which each activity is taken into account.

Query

Column1

PROCESS_ORDER("Table1"."ACTIVITY")

Input

Output

Table1

CASE_ID : STRING

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'

'B'

Tue Jan 01 2019 13:02:00.000

'2'

'A'

Tue Jan 01 2019 13:03:00.000

'2'

'B'

Tue Jan 01 2019 13:04:00.000

Result

Column1 : INT

1

2

3

1

2

[2] Example with two cases in which only B values are taken into account.

Query

Column1

PROCESS_ORDER(REMAP_VALUES("Table1"."ACTIVITY", ['A', NULL]))

Input

Output

Table1

CASE_ID : STRING

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'

'B'

Tue Jan 01 2019 13:02:00.000

'2'

'A'

Tue Jan 01 2019 13:03:00.000

'2'

'B'

Tue Jan 01 2019 13:04:00.000

Result

Column1 : INT

null

1

2

null

1