On this tab, you can define or pass variables and parameters to the transformation. If multiple rows are passed to the transformation, the first row is used to set the parameters or variables. Use the table to set a variable to a static value, to another variable's value, or to the value of a column from the input stream (for a single row).
For each variable or parameter name that is added to table, you must assign a value to that parameter in either the Variable / Parameter to use field or the Static input value field. You cannot use both a variable and a static value.
| Option | Description |
|---|---|
| Variable / Parameter name |
Specify a unique name of the variable or parameter to pass to the transformation. For example, you can enter strings such as ParameterOne, ParameterTwo, etc. This name must be unique. Otherwise, you may adversely affect your data. |
| Variable / Parameter to use | The Variable / Parameter to use column is
for setting the names of variables and/or parameters that are defined and passed to
the child transformation. For this column, enter a value using one of the following methods:
Specify which field to set as a parameter or variable value. You can specify the variable using the ${} notation to automatically insert it in the child transformation instead of the field value it resolves to. For example, if you enter the variable ${Internal.Kettle.Version} which resolves to Pentaho_9.3, then everywhere the specified parameter is referenced in the child transformation, the field variable is replaced with Pentaho_9.3. For this column you have three ways to enter a value:
If you specify a field or value in Variable / Parameter to use, the Static input value column is disabled. When Variable / Parameter to use contains a valid value, the Inherit all variables from transformation check box does not affect the Variable/Parameter to use. |
| Static input value |
Specify a static input value for the variable/parameter name. For example, you may specify the Variable/Parameter name as ParameterOne and in the same row specify the Static input value as StaticInputValueOne. When the step runs the child transformation, the environment variable ${ParameterOne} resolves to StaticInputValueOne. Entering a value in the Static input value field disables the Variable / Parameter to use field. |
| Inherit all variables from transformation (check box) | Use this check box to determine which variables take precedence when the Transformation Executor step is run. Select this check box to include all the variables
defined in the current transformation. When the step runs, the transformation
processes:
Note: If you specify a value in the
Variable / Parameter to use field for a
variable/parameter row, do not modify the value after selecting this check box.
Otherwise, you may adversely affect your data.
See Order of processing for more information. |
| Get Parameters (button) | Click this option to insert all the defined parameters of the specified transformation. The description of the parameter is inserted into the static input value field. |