INDEX_ACTIVITY_ORDER
Description
INDEX_ACTIVITY_ORDER returns the position of each activity within a case. Only not null activities are counted.
Syntax
INDEX_ACTIVITY_ORDER ( activity_table.column )
activity_table.column: A column of an activity table. Usually, the activity column of an activity table is used.
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 with null values. | ||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||
|
Result
INDEX_ACITIVTY_ORDER returns an INT column which gives for each not null activity in the activity table the position within a case. The resulting column is temporarily added to the activity table.
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. | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|