Description
This step allows you to set variables in a job or in the virtual machine. It accepts one (and only one) row of data to set the value of a variable. Here are the possible scope settings:
- Valid in the virtual machine: the complete virtual machine will know about this variable.
Warning: this makes your transformation only fit to run in a stand-alone fashion. Running on an application server like on the Pentaho framework can become a problem. That is because other transformations running on the server will also see the changes this step makes. - Valid in the parent job: the variable is only valid in the parent job.
- Valid in the grand-parent job: the variable is valid in the grand-parent job and all the child jobs and
transformations. - Valid in the root job: the variable is valid in the root job and all the child jobs and transformations.
IMPORTANT : IT IS NOT POSSIBLE TO SET AND USE A VARIABLE IN THE SAME TRANSFORMATION. This is because all steps run in parallel.
Variable usage
Refer to Variables wiki page for a description of the use of variables.