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 RowID 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 RowID.

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 RowID 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

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.

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.