This node takes a string that consists of tokens which are separated by a certain patter (e.g. TAB, space, etc.) and separates a certain number of these tokens from the beginning of the string. It converts them either in floating point numbers or keeps them as strings. The new values are stored in one new column (as a collection or a vector) or each in a separate new column. If the string consists of more than the extracted tokens, the remaining part of the string can be stored in a new column for further processing.
The string must be comprised of simple tokens; there is no support for quoted tokens, different decimal separators, or comment lines in the file.
The node operates row-based. It can be executed in streaming mode.
- Type: Data DataTable with column to extract tokens from
- Type: Data DataTable with additional column(s) carrying the extracted items from the input column
KNIME Labs > Wide Data
Make sure to have this extension installed:
KNIME Nodes for Wide Data (many columns)
Update site for KNIME Analytics Platform 3.7:
KNIME Analytics Platform 3.7 Update Site