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.

Views

This node has no views

Workflows

• justknimeit-27KNIME Hub
• !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
• (3D) Fragment library design workflowKNIME Hub
• 0_install_AI_extensionsKNIME Hub
• 00 Data GenerationKNIME Hub
• Show all 5485 workflows

Links

• Knime Email node recipients limitby AnotherFraudUser on 2021-10-27

  forum.knime.com/p/137975
• Help to Optimize Workflow for Processing Multiple URLsby qqilihq on 2023-11-13

  forum.knime.com/p/241526
• Help with HTTP-Retrieverby qqilihq on 2022-06-07

  forum.knime.com/p/159568
• How to Create dynamic Excel and CSVby knimediger on 2022-02-11

  forum.knime.com/p/147562

Developers