There is a task I need to accomplish and not sure how can I do it:
I have an CSV like so:
Now I need to copy and split those rows by the value of a BrandType text column and “/”
I’ve tried a number of ways but can’t figure it out. Any assistance at all much appreciated.
Hi @Nemrod , and welcome to the Knime Community.
Can you explain that are the rules behind the slashes? When do you have a double slash and when do you have a single slash? Is that the BrandType always starts with a double slash?
And also, why does the last time
;T;X;XX; not have a slash like
yesx, thank you
double // is only the first one, later single “/”
Maybe my mistake, X is a symbol for other data, not containing any special characters
Thanks for confirming @Nemrod about the slashes.
My last question was not about the X. I understood that the X was other column, other data. The question was more about why did the brandtype T not start with a slash, like /S did in the previous row. I think that was a mistake.
In any case, I am assuming that it was supposed to be /T.
I put something together for you, that looks like this:
Input data (same as yours):
And here’s the workflow:
duplicate rows based on column text value.knwf (13.9 KB)
yes, this was my mistake, thank you so much!!!
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.