Skip to main content

Get Variables

Description

Get Variables reads process, environment, or user-defined variables and converts them into fields in the data stream. Use this step when your workflow needs to access variable values — such as configuration parameters, file paths, or values set by a previous process entry — and make them available as row-level fields for downstream processing. All variable values are returned as strings; use the Rename Fields step's Meta-data tab to convert them to other data types if needed.

Configurations

Field NameDescription
Step nameSpecify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow.
NameSpecify the name of a field to store a particular variable value.
VariableYou may enter variables as complete strings; for example, you can specify: ${java.io.tmpdir}/tempfile.txt and it will be expanded to /tmp/tempfile.txt on Unix-like systems. Or you may choose a variable from the list (Ctrl+space).
TypeSpecify the field type: String, Date, Number, Boolean, Integer, BigNumber, Serializable, or Binary.
FormatSpecify the format of the field after the type has been determined.
LengthSpecify length of the field.

-For Number: Total number of significant figures in a number;

- For String: total length of string;

- For Date: length of printed output of the string (for example, entering 4 would only return the year).

PrecisionSpecify precision,

-For Number: Number of floating point digits.

- Not used for String, Date, or Boolean.

CurrencySpecify currency format to interpret numbers with currency symbols. For example, $10,000.00 or E5.000,00.
DecimalSpecify decimal separator:

- a period (".") or comma (",") for number values.

GroupSpecify a group indicator e,g to use a period (".") or comma (",") for number values.
Trim TypeSpecify Trim Type for the field before processing: select either none, left, right, or both (left and right).