Reset ROWID after Joiner

Attempts to reset the ROWID to just the Specified table ROWID from prior to the last JOINER node. If the ROWID is from the concatenation of rows from several joiner nodes, specify a different concatenation character on the JOINER and then use that here as the separator


@takbb Brian Bates 24 November 2022

Options

Use ROWD from Left or Right of ROWID concatenation

Choose whether the new ROWID should be taken from the ROWID prior to (Left) or after (Right) of the concatenation character. Auto causes it to take from the Left unless this is not available, in which case it takes from the Right.%%00010%%00010In the event that there is a resultant clash of ROWIDs, a numeric suffix is applied (1), (2) and so on. This is performed by the ROWID node, so see that node's documentation for more details

Separate RowID at which character

Specify the character used to separate ROWIDs during the Joiner Operation

Nodes

• RowID2 ×
• Column Filter1 ×
• Component Input1 ×
• Component Output1 ×
• Single Selection Configuration1 ×
• String Configuration1 ×
• String Manipulation1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Quick Forms

Links

• No links available