Skip to main content

Celonis Product Documentation

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