Convert list of collections to string

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

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

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.

4 Likes