RowID

This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementRowID

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.

Popular Predecessors

Popular Successors

  • No recommendations found

Views

This node has no views

Workflows

Links

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.

Installation

To use this node in KNIME, install the extension KNIME Base nodes from the below update site following our NodePit Product and Node Installation Guide:

v4.7

A zipped version of the software site can be downloaded here.

Plugin provider: KNIME AG, Zurich, Switzerland
Plugin version: 4.7.0.v202211291414
On NodePit since: 2022-12-06
Last update: 2023-03-21
Tags: Deprecated
KNIME versions: Since v4.2