Set Variables transform Icon Set Variables

Description

The Set Variables transform allows you to set variables in a workflow or in the virtual machine.

This transform accepts one (and only one) row of data to set the value of a variable. If you want to set a variable from a pipeline that processes multiple lines of data, make sure you isolate a single row before setting a variable.

Supported Engines

Hop Engine

Supported

Spark

Maybe Supported

Flink

Maybe Supported

Dataflow

Maybe Supported

Options

Option Description

Transform name

Name of the transform.

Apply formatting

When this option is set, it formats the value (date, numbers etc.) according to the format options. Otherwise no formatting is done.

Field Name

Name of the field that is used

Variable Name

Name of the variable to set (without ${…​} or %%…​%% sigils)

Variable scope type

Define the scope of the variable, possible options are:

  • Valid in the virtual machine: the complete virtual machine will know about this variable.

  • Valid in the parent workflow: the variable is only valid in the parent workflow.

  • Valid in the grand-parent workflow: the variable is valid in the grand-parent workflow and all the child workflows and pipelines.

  • Valid in the root workflow: the variable is valid in the root workflow and all the child workflows and pipelines.

Default value

Value that will be set for empty rows