0 ×

Insert Column Header

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

Updates column names of a table according to the mapping in second dictionary table. The dictionary table needs to contain two columns, one of which contains the lookup (i.e. the column names of the table to be renamed), the other column containing the new column names. The lookup column may be the RowID column.

If the assigned new value in the value column is missing, the original column name will be retained. If the lookup column contains duplicates of the original column names, the node will fail.

Options

Lookup column
The column in the 2nd input containing the "old" names of the columns.
Value column
The column in the 2nd input containing the "new" names of the columns.
Fail if no assignment in dictionary table
If selected, the node fails if there is no matching entry of a column name in the dictionary table. Otherwise it will keep the original column name

Input Ports

Icon
Table whose columns are to be renamed.
Icon
Table containing two columns: lookup and new value.

Output Ports

Icon
Input table, whereby the columns are renamed according to the dictionary.

Best Friends (Incoming)

Best Friends (Outgoing)

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.