IconRowID0 ×

StreamableKNIME Base Nodes version 3.6.0.v201807061308 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: Row0, 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 if the "Enable hiliting" option is disabled.

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: Row0, 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

The data table to be processed.

Output Ports

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

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Update Site

To use this node in KNIME, install KNIME Base Nodes from the following 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.