Applies to:  CELONIS 4.3 CELONIS 4.4 

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

Example with two cases in which each activity is taken into account.
Query
Column1
PROCESS_ORDER("Table1"."ACTIVITY")
Input
Table1
CASE_ID : STRINGACTIVITY : STRINGTIMESTAMP : DATE
'1''A'
Sun Jan 01 2017 13:00:00.000
'1''B'
Sun Jan 01 2017 13:01:00.000
'1''B'
Sun Jan 01 2017 13:02:00.000
'2''A'
Sun Jan 01 2017 13:03:00.000
'2''B'
Sun Jan 01 2017 13:04:00.000
Output
Result
Column1 : INT
1
2
3
1
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
Table1
CASE_ID : STRINGACTIVITY : STRINGTIMESTAMP : DATE
'1''A'
Sun Jan 01 2017 13:00:00.000
'1''B'
Sun Jan 01 2017 13:01:00.000
'1''B'
Sun Jan 01 2017 13:02:00.000
'2''A'
Sun Jan 01 2017 13:03:00.000
'2''B'
Sun Jan 01 2017 13:04:00.000
Output
Result
Column1 : INT
null
1
2
null
1



  • No labels