Convert String column to KNIME List Column after transposing table
Hi community, after some own experiments I figured out that when using the Table Transposer Node you might get out a Column which will be represented as String but you know that it needs to become a List for further procession (like using Ungroup Node).
Therefore I always forget how to create that list.
So imagine you will have the new column Transposed Column with a string like:
Yes, I’m using them for data annotation.$Annotating engineering data in CRC project$Yes, I’m using them to provide a search engine.
In this example I have used a $ char to be sure I can split the string and generating a correct List after all (this is the crucial point because within the string there might be a high probability that u have used commas within one list item and can not split on them).
With this pre processing i now can use a Cell Splitter to select the column and config the output to be As list.
I would like to hear from you if there is a delimiter other than $ to be really sure that the splitting succeeds at any time?