ACTIVITY_LEAD
Description
ACTIVITY_LEAD returns the row of the activity table that follows the current row by offset number of rows within a case. The resulting column is a temporary column of the activity table.
Syntax
ACTIVITY_LEAD ( activity_table.column [, offset ] )
activity_table.column: A column of an activity table.
offset: The number of non-NULL values following the current row in the provided column. The default value is 1.
NULL handling
The leading value for a NULL value is the same value as the leading value of the last non-NULL value. The offset parameter counts only non-NULL values.
Use Cases
ACTIVITY_LEAD
can be used for Activity SequencesACTIVITY_LEAD
can be used for FallBack StatusACTIVITY_LEAD
can be used for Ping-Pong-Cases.
Examples
[1] Simple example for ACTIVITY_LEAD returning the next activity within a case. For the last row of each case, NULL is returned: | ||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||
|
[2] Example for ACTIVITY_LEAD with offset = 2. ACTIVITY_LEAD returns the activity from the row that follows the current activity by 2 rows: | ||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||
|
[3] Null activities are skipped for calculation of ACTIVITY_LEAD: | ||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||
|