Collection to String

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)
Fail if no matching columns
Should the node execution fail if there are no matching collection columns?
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

Popular Predecessors

Popular Successors

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.

Installation

To use this node in KNIME, install the extension Vernalis KNIME Nodes from the below update site following our NodePit Product and Node Installation Guide:

v5.3

A zipped version of the software site can be downloaded here.

Plugin provider: Vernalis Research, UK
Plugin version: 1.36.7.v202405281205
On NodePit since: 2024-07-11
Last update: 2024-11-21
Tags: Streamable
KNIME versions: v5.3, v5.2, v5.1, v4.7, v4.6, v4.5, v4.4, v4.3, v4.2, v4.1, v4.0, v3.7

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!