0 ×

Extract Table Spec

KNIME Base Nodes version 4.2.2.v202009011342 by KNIME AG, Zurich, Switzerland

Node extracting the meta information from the input table (column names, types, etc.) The meta information is referred to as the table data specification and contains information such as column names, types, domain values (list of possible values for categorical columns) and lower and upper bounds. It also contains the information which of the columns have a view handler associated (optional operation). Each column in the input table is represented as a row in the output. This node can be used in conjunction with the Insert Column Header node, where the column names are extracted from the input table, then modified in the workflow and later merged back into the main table.

Options

Extract property handlers: If checked the information which of the columns have property handlers e.g. color handler associated is extracted, otherwise not.
Possible values as collection: If checked, the possible values of each columns are extracted as possible values, otherwise not.

Input Ports

: The input table to extract the psec from.

Output Ports

: The output table containing the spec information of the input table.

Best Friends (Incoming)

Extract Table Dimension (11 %)
CSV Reader (8 %)
Column Filter (6 %) Streamable
File Reader (5 %) Streamable
Column Rename (4 %) Streamable
Show all 251 recommendations

Best Friends (Outgoing)

Column Filter (9 %) Streamable
Row Filter (8 %) Streamable
Joiner (6 %)
Transpose (4 %)
GroupBy (4 %)
Show all 283 recommendations

Workflows

01_Accessing_Transforming_and_Modeling_Time_Series (KNIME Hub)
01_Accessing_Transforming_and_Modeling_Time_Series (KNIME Hub)
01_Additional_Visualizations (KNIME Hub)
01_AutoML_Component_via_Interactive_Views (KNIME Hub)
01_Clickstream_Analysis (KNIME Hub)
Show all 122 workflows

Installation

To use this node in KNIME, install KNIME Base nodes from the following update site:

KNIME 4.2

A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped update site.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.

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.