Create a complex and a dynamic complex variable

  1. Open the process.
  2. On the Modeling bar, click Variables.

    The Variables page appears.

  3. On the Type list, select either option:
    • Complex: To create a static complex variable.

    • Dynamic Complex: To create a dynamic complex variable.

  4. Enter a Name and ID for the variable.
  5. Click Configure.

    The Complex Variable or Dynamic Complex Variable page appears depending on the selection.

  6. To configure the number of rows and columns for the complex variable (initially, if it is dynamically updated), enter the number of Rows and Columns, and then click Apply.
    Note To set up a null complex variable, keep the default values for Rows and Columns, (1 and 1) and click Apply. A message indicates that members are not set for this complex variable so the value will be Null. This message may not appear for complex server variables.
  7. You can change the dimension of rows and columns. For example, if the number of rows and columns is set to 3 and 3 respectively, changing the dimension to 2 and 3 deletes one row but keeps the same number of columns.
    Note You can delete only the most recently added row or column.
  8. Click OK.
    Note
    • Create the Dynamic Complex variables in the same way as complex variables. The only difference is that for a dynamic complex variable, the number of rows and columns is dynamic; they are not set at design time but are based on the return result set, such as a web service or database query.

    • The variable mappings for dynamic complex variable cells are only for initial creation and are not retained. A static complex variable retains its variable mappings throughout the job. Every time a mapped variable value is updated in the job, it is reflected in the static complex variable cell.