Icon

Extract Table Spec

The Extract Table Spec node lists each column from the connected table as a record in the output table. The output table includes the column name, column index, and lower and upper bounds (for numeric fields).

The configuration menu contains two options:

- Extract Property Handlers: This option displays additional columns that indicate if a given field has property handlers such as size or color (from the Size Manager or Color Manager nodes, respectively).

- Possible Values as Collection: This option includes an additional field which displays a collection of possible values from categorical string fields.

Extract Table Spec The Extract Table Spec node lists each column from the connected table as a record inthe output table. The output table includes the column name, column index, and lowerand upper bounds (for numeric fields).The configuration menu contains two options:- Extract Property Handlers: This option displays additional columns that indicate if agiven field has property handlers such as size or color (from the Size Manager or ColorManager nodes, respectively). - Possible Values as Collection: This option includes an additional field which displaysa collection of possible values from categorical string fields. The Extract Table Spec node, with both of its optionsturned on, reveals valuable information about theinput table. Especially useful is a column of columnnames, which can be used to dynamically renamecolumn headers. Night Heron Data, 2023 Input some dataView tablemeta data Table Creator Extract Table Spec Extract Table Spec The Extract Table Spec node lists each column from the connected table as a record inthe output table. The output table includes the column name, column index, and lowerand upper bounds (for numeric fields).The configuration menu contains two options:- Extract Property Handlers: This option displays additional columns that indicate if agiven field has property handlers such as size or color (from the Size Manager or ColorManager nodes, respectively). - Possible Values as Collection: This option includes an additional field which displaysa collection of possible values from categorical string fields. The Extract Table Spec node, with both of its optionsturned on, reveals valuable information about theinput table. Especially useful is a column of columnnames, which can be used to dynamically renamecolumn headers. Night Heron Data, 2023 Input some dataView tablemeta data Table Creator Extract Table Spec

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: johnemery
Created at: 2023-05-26
On NodePit since: 2023-05-26
Last update: 2024-05-03
Created with KNIME version: v4.7.2
Tags: extract table specnode bitesnight heron data

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!