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

  • Column Aggregator3 %
  • Table Row to Variable3 %
  • ARFF Writer2 %
  • Loop End2 %
  • Joiner2 %
  • Component Output2 %
  • DB Table Creator2 %
  • Column Combiner2 %
  • Excel Writer2 %
  • Table Row to Variable1 %
  • GroupBy1 %
  • Table Manipulator1 %
  • SDF Writer1 %
  • Excel Writer (XLS)1 %
  • Container Output (Table)1 %
  • Write Geometries into Shapefile1 %
  • Table Column to Variable1 %
  • CSV Writer1 %
  • Column Appender1 %
  • Column Rename1 %
  • Ungroup1 %
  • Run Garbage Collector1 %
  • Insert into List1 %
  • Collection to String1 %
  • Create Collection Column1 %
  • Split Collection Column1 %
  • Java Snippet1 %
  • Loop End1 %
  • Chunk Loop Start1 %
  • Table Row To Variable Loop Start1 %
  • Concatenate1 %
  • Cell Splitter1 %
  • Cell Splitter By Position1 %
  • Column Renamer1 %
  • Extract Column Header1 %
  • Column Resorter1 %
  • One to Many1 %
  • Constant Value Column1 %
  • Cross Joiner1 %
  • Duplicate Row Filter1 %
  • Column Filter1 %
  • Row Splitter1 %
  • Row Filter1 %
  • Joiner1 %
  • Missing Value1 %
  • Rank1 %
  • RowID1 %
  • Row Sampling1 %
  • Sorter1 %
  • Column Splitter1 %
  • String Manipulation1 %
  • String Manipulation (Multi Column)1 %
  • String Replacer1 %
  • Transpose1 %
  • Rule-based Row Filter1 %
  • Rule Engine1 %
  • Rule-based Row Splitter1 %
  • End IF1 %
  • Column Expressions1 %
  • Excel Reader1 %
  • Strings To Document1 %
  • Table View1 %
  • String to JSON1 %
  • JSON Transformer1 %
  • Python Script (legacy)1 %
  • Python Script1 %
  • String to Date&Time1 %
  • XPath1 %
  • Regex Extractor1 %
  • Column Rename (Regex)< 1 %
  • Value Counter< 1 %
  • Association Rule Learner< 1 %
  • Reference Row Splitter< 1 %
  • DB Writer< 1 %
  • Pie/Donut Chart< 1 %
  • Excel Writer (XLS) (deprecated)< 1 %
  • Send to Power BI< 1 %
  • JSON Path< 1 %
  • Reference Row Filter< 1 %
  • POST Request< 1 %
  • N-Gram Extractor< 1 %
  • Append to Collection< 1 %
  • List To Set< 1 %
  • Empty Collection to Missing< 1 %
  • Collection Size< 1 %
  • Copy/Move Files (legacy)< 1 %
  • Table Column to Variable< 1 %
  • Table Column to Variable< 1 %
  • Table Row to Variable< 1 %
  • CSV Writer (deprecated)< 1 %
  • Loop End (Column Append)< 1 %
  • Group Loop Start< 1 %
  • Recursive Loop Start< 1 %
  • Variable Loop End< 1 %
  • Scorer< 1 %
  • Cell Replacer< 1 %
  • String To Number< 1 %
  • Column Appender< 1 %
  • Insert Column Header< 1 %
  • Domain Calculator< 1 %
  • Reference Column Resorter< 1 %
  • Set Operator< 1 %
  • String Replace (Dictionary)< 1 %
  • Rule-based Row Filter (Dictionary)< 1 %
  • CASE Switch Data (End)< 1 %
  • IF Switch< 1 %
  • DB Table Creator< 1 %
  • Bar Chart< 1 %
  • Variable Expressions< 1 %
  • Table to PDF< 1 %
  • OpenBabel< 1 %
  • Math Formula< 1 %
  • Excel Sheet Appender (XLS)< 1 %
  • Term Co-Occurrence Counter< 1 %
  • Multiple Selection Configuration< 1 %
  • Table to JSON< 1 %
  • Columns to JSON< 1 %
  • Object Inserter< 1 %
  • R Snippet< 1 %
  • String To XML< 1 %

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.