process-mining
latest
false
UiPath logo, featuring letters U and I in white

Process Mining

Last updated Jul 23, 2025

Activity Configuration: Defining activity order

The Activity_order field is used as a tie breaker when two events are happening on the same timestamp.

Option 1: SQL configuration

The following code shows an example of configuring Activity_order with a SQL CASE statement:
case
            when tableA."Activity" = 'ActivityA'
                then 1
            when tableA."Activity" = 'ActivityB'
                then 2
            when tableA."Activity" = 'ActivityC'
                then 3
            when tableA."Activity" = 'ActivityD'
                then 4
    end as "Activity_order"    case
            when tableA."Activity" = 'ActivityA'
                then 1
            when tableA."Activity" = 'ActivityB'
                then 2
            when tableA."Activity" = 'ActivityC'
                then 3
            when tableA."Activity" = 'ActivityD'
                then 4
    end as "Activity_order"

Option 2: CSV seeds file

Instead of using a SQL CASE statement, you can define Activity_order using the activity_configuration.csv file .
The following illustration shows an example activity_configuration.csv file:


Recommendations

Most UiPath app templates come with predefined fields for activity configuration, which you can adapt to your specific business requirements. If predefined fields are unavailable or insufficient, you can always create custom fields using either SQL or the activity_configuration.csv seeds file, as outlined.

  • Option 1: SQL configuration
  • Option 2: CSV seeds file
  • Recommendations

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo
Trust and Security
© 2005-2025 UiPath. All rights reserved.