INDEX_ACTIVITY_ORDER_REVERSE
Applies to: CELONIS 4.7
Description
INDEX_ACTIVITY_ORDER_REVERSE returns the reverse position of each activity within a case. Only not null activities are counted.
Syntax
INDEX_ACTIVITY_ORDER_REVERSE ( table.column )
column: Column which has to be joinable to the activity table
NULL handling
If a row is NULL, then NULL will also be returned. NULL values do not influence the position of the non-NULL activities.
[1] INDEX_ACTIVITY_ORDER_REVERSE with null values.
|
Examples
[2] Example with two cases in which each activity is taken into account.
|
[3] Example with two cases in which only B values are taken into account.
|