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

  • Duplicate Row Filter5 %
  • GroupBy5 %
  • Create Collection Column4 %
  • Rule Engine4 %
  • Column Filter3 %
  • Reference Row Filter2 %
  • Table Manipulator2 %
  • Loop End2 %
  • Java Snippet2 %
  • Reference Row Splitter2 %
  • Joiner2 %
  • XPath2 %
  • RDKit Substructure Filter2 %
  • Recursive Loop End2 %
  • Rule-based Row Filter (Dictionary)2 %
  • Column Resorter1 %
  • Joiner1 %
  • Missing Value1 %
  • Column Expressions1 %
  • Math Formula1 %
  • JSON Path1 %
  • Python Script1 %
  • Concatenate1 %
  • Pivoting1 %
  • Item Set Finder (Borgelt)1 %
  • List To Set1 %
  • Set To List1 %
  • Collection Size1 %
  • Cell Splitter1 %
  • Column Aggregator1 %
  • Subset Matcher1 %
  • Column Rename1 %
  • Sorter1 %
  • Collection to String1 %
  • Split Collection Column1 %
  • Variable to Table Row1 %
  • Row Filter1 %
  • RowID1 %
  • String Manipulation1 %
  • Ungroup1 %
  • Rule-based Row Splitter1 %
  • Extract Table Spec1 %
  • Association Rule Learner (Borgelt)1 %
  • JSON to Table1 %
  • Stop Word Filter1 %
  • Test Data Generator1 %
  • Column Appender1 %
  • Loop End1 %
  • Column Renamer1 %
  • Association Rule Learner1 %
  • Excel Reader1 %
  • String Manipulation (Multi Column)< 1 %
  • Distance Matrix Calculate< 1 %
  • Modify Time< 1 %
  • RDKit Molecule Substructure Filter< 1 %
  • Column List Loop Start< 1 %
  • Cell Replacer< 1 %
  • Nominal Value Row Filter< 1 %
  • OpenBabel< 1 %
  • Inject Variables (Data)< 1 %
  • Chunk Loop Start< 1 %
  • Rule-based Row Filter< 1 %
  • Conformal Scorer< 1 %
  • Column Splitter< 1 %
  • Track Spots (Subpixel localization, multi-channel)< 1 %
  • Empty Collection to Missing< 1 %
  • Constant Value Column< 1 %
  • Double To Int< 1 %
  • Row Splitter< 1 %
  • Reference Column Resorter< 1 %
  • String Replace (Dictionary)< 1 %
  • Transpose< 1 %
  • Empty Table Switch< 1 %
  • CASE Switch Data (Start)< 1 %
  • Molecule Type Cast< 1 %
  • Term Neighborhood Extractor< 1 %
  • Columns to JSON< 1 %
  • Date&Time to String< 1 %
  • RDKit From IUPAC< 1 %
  • Conformal Predictor Classifier< 1 %
  • Number To String< 1 %
  • Lag Column< 1 %
  • End IF< 1 %
  • MoSS< 1 %
  • Tika Language Detector< 1 %
  • Term To String< 1 %
  • JSON Column Combiner< 1 %
  • String to JSON< 1 %
  • Image to DataRow< 1 %
  • Spot Detection (Subpixel localization)< 1 %
  • Track Spots (Subpixel localization)< 1 %
  • String to Date&Time< 1 %
  • Moving Aggregation< 1 %
  • RDKit Calculate Charges< 1 %

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.