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:
|red, blue, green|
|black, green, red|
What I would like to have is something like the following:
|Column Red||Column Blue||Column Green||Column Black|
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!