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!