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")
Input
Table1
case : INTactivity : STRINGtimestamp : DATE
1
'A'
Mon Feb 01 2016 01:00:00.000
1
'B'
Mon Feb 01 2016 02:00:00.000
1
'C'
Mon Feb 01 2016 03:00:00.000
2
'A'
Mon Feb 01 2016 01:00:00.000
2
'B'
Mon Feb 01 2016 02:00:00.000
2
'C'
Mon Feb 01 2016 03:00:00.000
2
'D'
Mon Feb 01 2016 04:00:00.000
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)
Input
Table1
case : INTactivity : STRINGtimestamp : DATE
1
'A'
Mon Feb 01 2016 01:00:00.000
1
'B'
Mon Feb 01 2016 02:00:00.000
1
'C'
Mon Feb 01 2016 03:00:00.000
2
'A'
Mon Feb 01 2016 01:00:00.000
2
'B'
Mon Feb 01 2016 02:00:00.000
2
'C'
Mon Feb 01 2016 03:00:00.000
2
'D'
Mon Feb 01 2016 04:00:00.000
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")
Input
Table1
case : INTactivity : STRINGtimestamp : DATE
1
'A'
Mon Feb 01 2016 01:00:00.000
1
'B'
Mon Feb 01 2016 02:00:00.000
1
'C'
Mon Feb 01 2016 03:00:00.000
2
'A'
Mon Feb 01 2016 01:00:00.000
2
null
Mon Feb 01 2016 02:00:00.000
2
'B'
Mon Feb 01 2016 03:00:00.000
Output
Result
Column1 : STRING
'B'
'C'
null
'B'
'B'
null


  • No labels