Applies to: CELONIS 4.6
Description
ACTIVITY_LEAD returns the activity from the row that follows the current activity by offset number of rows within a case. Null activities are skipped.
Syntax
ACTIVITY_LEAD ( table.column [, offset ] )
- column: String column which has to be joinable to the activity table.
- offset: The number activities following the current activity. The default value is 1.
Examples
[1] Simple example for ACTIVITY_LEAD returning the next activity within a case. If activity has no following
activity, NULL is returned.
Query
Column1
ACTIVITY_LEAD("Table1"."activity")
Output
Result
Column1 : STRING |
---|
'B' |
'C' |
null |
'B' |
'C' |
'D' |
null |
[2] Example for ACTIVITY_LEAD with offset = 2. ACTIVITY_LEAD returns the activity from the row that follows the
current activity by 2 rows.
Query
Column1
ACTIVITY_LEAD("Table1"."activity", 2)
Output
Result
Column1 : STRING |
---|
'C' |
null |
null |
'C' |
'D' |
null |
null |
[3] Null activities are skipped for calculation of ACTIVITY_LEAD.
Query
Column1
ACTIVITY_LEAD("Table1"."activity")