Hi Paul,

The sorting is an additional information that is only relevant in Celonis, and which serves to sort activities having a same timestamp in a specific order.

So basically, at each transformation where you identify an activity, you should add a _SORTING field with a fixed number.

But first things first, you need to add this field to your activity table definition. It is of type Integer:

_SORTING INT,

And then based on the expected happy flow, you give each activity a 'value' to have them sorted out the expected way:

'Create' activity = 10, any 'Change' activity = 20, 'Send' activity = 30 etc...

SQL syntax is quite easy and similar to the activity description you have added in the transformation. For example:

10 AS _SORTING,

Note that it is recommended to use a 2 or 3 digits number to enable adding new activities in between if needed at a later stage.

Also, you can give each activity a dedicated number, or group some activities under one same number. I usually consider 'Change' activities under a same number unless the process contains such activities that can only happen after others, or if I need to use the sorting ID later in the analysis (where it is easier to use an ID than a description)

kind regards

Marc