Convert String List Column to Table

Hi, 

I haven't worked a lot in Knime with strings and java snippets and probably that's why I'm struggeling with the following problem. 

I have one string column, where each column say contains a list of colors: 

Column Color
red, blue, green
red, black
black, green, red

What I would like to have is something like the following: 

Column Red Column Blue Column Green Column Black
yes yes yes no
yes no no yes
yes no yes yes

This is probably really easy but I have the following problems: 

- how can I count the number of unique colors in order to specify the number of columns

- how can I check that a certain color substring is contained in a row and subsittute this by yes or no

Thank you very much! 

Here is an example of one way you can do this. I've heavily used Java snippets, someone else may offer you an example using nodes that do what the java snippets do. 

 

 

Thank you very much! This was exactly what I was looking for and I think I now should be able to transfer this workflow to my case! 

Thank you very much! This was exactly what I was looking for and I think I now should be able to transfer this workflow to my case! 

oops. me too not worked more on it, only heard and worked on the basics.

kolikkopeli