Create a complex and a dynamic complex variable
- Open the process.
-
On the Modeling bar, click
Variables.
The Variables page appears.
-
On the
Type list, select either
option:
-
Complex: To create a static complex variable.
-
Dynamic Complex: To create a dynamic complex variable.
-
- Enter a Name and ID for the variable.
-
Click
Configure.
The Complex Variable or Dynamic Complex Variable page appears depending on the selection.
-
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.
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.To set up a null complex variable, keep the default values for Rows and Columns, (1 and 1) and click
-
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.
You can delete only the most recently added row or column.
-
Click
OK.
-
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.
-