Supported functions for object-centric transformations
Not all functions are enabled for Celonis transformations. The functions and operators on this list are enabled for use in custom transformations for object-centric process mining.
The list of enabled functions for case-centric transformations is different. You can find it at Supported functions for case-centric transformations.
Aggregate operators
AVG
COUNT
FIRST_VALUE
LAST_VALUE
LAG
LEAD
MIN
MAX
SUM
Date part functions
YEAR
QUARTER
MONTH
WEEK
DAYOFYEAR
DAYOFMONTH
DAYOFWEEK
HOUR
MINUTE
SECOND
Window rank functions
RANK
ROW_NUMBER
Scalar functions
CAST
COALESCE
CONCAT
DATEDIFF
EXTRACT
LEFT
LENGTH
LOWER
LPAD
LTRIM
NULLIF
RANDOM
REPLACE
RIGHT
SUBSTRING
TIMESTAMPDIFF
TRIM
UPPER