Convert list of collections to string

KNIME Analytics Platform
1

Hello
I have a table that contains columns of type list of collections. I want to save the table to excel file. I cant do that because Excel writes node recognizes just other types for saving. What should I do?

Best
Malik

2

Hi,

Attach “Split Collection Column” node to split the collection and then use “Column combiner”
node to concatenate splitted columns back to column of String type. Then you should be able
to write data to XLSX.

Martin K.

3 Likes
3

Use “String Manipulation” node, with formula: joinSep(",", $YOUR_COLLECTION_COLUMN$)
It will create a string with all elements separated by comma.

Change “,” to another symbol to be used as a delimiter.

5 Likes