The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at
http://knime.com.
RowID
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.
Dialog 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.
Ports
Input Ports
0 |
The data table to be processed.
|
Output Ports
0 |
Data with the replaced RowID and/or a new column with the current RowID values.
|
This node is contained in KNIME Base Nodes
provided by KNIME GmbH, Konstanz, Germany.