Skip to main content

Get help for ARIS Process Mining functions and services

Use parameters in transformation statements

In transformation statements, you can use parameters as placeholders for values of a certain type. The placeholder is replaced by the actual value when the transformation statement is executed.

In the SQL statements, you can insert global parameters that are specified only for a certain data set.

When using dynamic parameters or other parameters of the Date data type, such as "Task start time", you can convert these parameters into any format using the format SQL function. For details on how to use the format function, see the Supported SQL functions chapter.

Procedure. Procedure

  1. Create a transformation or open an existing transformation.

  2. Place the cursor in the SQL statement.

  3. Open the Parameters panel in the side panel.

  4. Select a parameter.

    The selected parameter is placed at the cursor position.

  5. You can view the currently specified values of the parameters inserted into the statement. Enable the Parameters resolved option.

    A second window opens with the same statement, in which the parameters are replaced by the currently specified values.

The inserted parameters are available in the transformation.

You can set each parameter individually when you load the data into the data set.