0 ×

Collection to String

StreamableVernalis custom KNIME nodes package version 1.30.1.v202103301200 by Vernalis (R&D), UK

The node converts one or more collection columns to a string representation. Each individual cell in the collection is converted using its 'toString()' method. Missing cells within collections can optionally be skipped. The separator string between cells can be changed. Individual cells can have prefixes and/or suffixes, and the entire collection can have a prefix and/or suffix. Any of these can include 'special' characters e.g. \t (tab), \n (new line) etc., or be left empty

This node was developed by Vernalis (Cambridge, UK) . For feedback and more information, please contact knime@vernalis.com

Options

Collection Columns
The List or Set column(s) to convert to strings
Replace input columns?
Should the input columns be replaced in situ? If not, new String columns will be appended to the table, with the suffix ' (String)' added to their name(s)
Skip missing values in collections?
Should missing value cells in collections be skipped or included in the output String
Prefix
The prefix which is placed at the start of the whole string
Cell Prefix
The prefix which is placed before each individual cell representation
Separator
The character(s) to be placed between each cell
Cell Suffix
The suffix which is placed after each individual cell representation
Suffix
The suffix which is placed at the end of the whole string

Input Ports

Icon
Table containing one or more collection (Set or List) columns

Output Ports

Icon
Table containing the input table with selected collection columns converted to Strings

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

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.