Welcome > Workflow > Variables > Create process variables > Create a complex and a dynamic complex variable

Create a complex and a dynamic complex variable

Create complex and Dynamic complex variables for a process.

See Create process variables

Complex variable

Create a complex variable to hold tabular or array-based data values, such as a list of product details.

  1. On the Type list, select Complex. (Default: String)
  2. By default, Column1 is added. To add more columns, do the following:
    1. Click for Columns.

      By default, the column Name is displayed as Column2. You cannot edit the column name.

    2. On the Type list select the column.
    3. Click Add.
    4. Add more columns as needed.

      You can modify and delete a column. You can only delete the most recently added columns.

  3. To configure the variable content, click Configure contents.

    The Configure complex variable content or Configure dynamic complex variable content page appears depending on the selection. By default, single row is added under each column.

  4. To configure the number of rows for the complex/Dynamic complex variable (initially, if it is dynamically updated), enter or select the No. of rows (default: 1) and then click Apply.
    The selected number or rows are displayed under each column. For example, if you have added two columns, and select the No. of rows as 6, six rows are added under Column1 and Column2.
  5. You can increment or decrement the value for number of rows. For example, if you have 2 columns and 6 rows, if you decrement the number of rows by 3 and click Apply, 3 rows are deleted, but the same number of columns (2) are retained.
    Note You can only delete the most recently added rows.
  6. Map the process or server variables for each cell using dynamic or static values.
  7. Click OK.
    Note 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.
  8. Click Save.

Dynamic complex variable

You can create dynamic complex variables at the server or process level. Both types of variables are created in the same way. However, the Process Initialization option is not available when setting up complex server variables.
  1. On the Type list, select Dynamic complex. (Default: String)
  2. By default, Column1 is added. To add more columns, do the following:
    1. Click for Columns.

      By default, the column Name is displayed as Column2. You cannot edit the column name.

    2. Select the column Type.
    3. Click Add.
    4. Add more columns as needed.

      You can modify and delete a column. You can only delete the most recently added columns.

  3. To configure the variable content, click Configure contents.

    The Configure complex variable content or Configure dynamic complex variable content page appears depending on the selection. By default, single row is added under each column.

  4. To configure the number of rows for the complex/Dynamic complex variable (initially, if it is dynamically updated), enter or select the No. of rows (default: 1) and then click Apply.
    The selected number or rows are displayed under each column. For example, if you have added two columns, and select the No. of rows as 6, six rows are added under Column1 and Column2.
  5. You can increment or decrement the value for number of rows. For example, if you have 2 columns and 6 rows, if you decrement the number of rows by 3 and click Apply, 3 rows are deleted, but the same number of columns (2) are retained.
    Note You can only delete the most recently added rows.
  6. Map the process or server variables for each cell using dynamic or static values.
  7. Click OK.
    Note

    • 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.

  8. Click Save.