Table Row to Variable

This node uses the first row of a data table to define new flow variables. The names of the variables are defined by the column names and the variable assignments (i.e. the values) are given by the values in the row. The variables are exposed using a variables out connection.

Options

Output as variables
Select the columns to be converted to flow variables. For each selected column, a flow variable is created. The name of the flow variable corresponds to the column name and the value corresponds to the value of the first row in that column.
If value in cell is missing
Behavior in case of missing values in the first row or an input table with no rows.
  • Fail: Ensures that the node will fail during execution if the input table is empty or contains missing values in the columns to convert.
  • Use defaults: Replaces missing values with the configured defaults. If a column has a type for which no flow variable type exists, the default value for missing strings will be output. If the column holds lists or sets of string, boolean, double, integer, or long, an empty list of the according type will be output. If the column holds lists or sets of another type, an empty string list will be output.
  • Ignore: Missing cells will not be converted and therefore be omitted from the output.
Default string
The default flow variable value for string columns in case of an empty input table or a missing value in the first row of the input table.
Default boolean
The default flow variable value for boolean columns in case of an empty input table or a missing value in the first row of the input table.
Default integer
The default flow variable value for integer columns in case of an empty input table or a missing value in the first row of the input table.
Default long
The default flow variable value for long columns in case of an empty input table or a missing value in the first row of the input table.
Default double
The default flow variable value for double columns in case of an empty input table or a missing value in the first row of the input table.

Input Ports

Icon
The table whose first row will be converted to variables.

Output Ports

Icon
Holds created flow variables.

Popular Successors

Views

This node has no views

Workflows

Links

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.