0 ×

RowID

DeprecatedKNIME Base Nodes version 4.3.2.v202103021015 by KNIME AG, Zurich, Switzerland

This node can be used to replace the RowID of the input data with the values of another column (by converting the values to a string) or a generated row id of the format: Row1, Row2. The user has additional options to ensure uniqueness and to handle missing values.

It can also be used to create a new column, which contains the RowID as a value.

If both options are selected the node appends a new column with the values of the current RowID to the table and replaces the current RowID with the values of the selected column or the generated row id.

Note: Highlighting does not work across this node.

Options

Replace RowID with selected column values
If selected the node replaces each RowID with the corresponding string value of the selected column or with a generated key.
New RowID column:
The column to replace the current RowID. If none is selected a row id is generated with the format: Row1, Row2, ...
Ensure uniqueness
If checked the node ensures uniqueness by appending a counter (x) to duplicates where x is incremented for each appearance.
Handle missing values
All missing values are replaced with '?' if this check box is ticked. We recommend activating the 'Ensure uniqueness' check box to handle any duplicate missing values.
Enable hiliting
If enabled, a map is maintained joining the old with the new RowID. Depending of the number of rows, enabling this feature might consume a lot of memory.
Create new column with the RowID values
If this is selected the node creates a new column with the value of the current RowID.
New column name:
The name of the new column that is being added to the table.

Input Ports

Icon
The data table to be processed.

Output Ports

Icon
Data with the replaced RowID and/or a new column with the current RowID values.

Best Friends (Incoming)

Workflows

Installation

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

KNIME 4.3

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.