0 ×

Extract Table Spec

KNIME Base Nodes version 4.2.3.v202011031328 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 146 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.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

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. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

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.