copy and duplicate rows based on column text value

Hi guys
There is a task I need to accomplish and not sure how can I do it:
I have an CSV like so:
;BrandType;column1;column2;
;//AE/AS;X;XX;
;//M/S/T;X;XX;

Now I need to copy and split those rows by the value of a BrandType text column and “/”
;BrandType;column1;column2;
;//AE;X;XX;
;/AS;X;XX;
;//M;X;XX;
;/S;X;XX;
;T;X;XX;
I’ve tried a number of ways but can’t figure it out. Any assistance at all much appreciated.

Thanks guys

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 ;/T;X;XX;?

yesx, thank you :slightly_smiling_face:
double // is only the first one, later single “/”
Maybe my mistake, X is a symbol for other data, not containing any special characters :slight_smile:

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):
image

Results:
image

And here’s the workflow:
duplicate rows based on column text value.knwf (13.9 KB)

4 Likes

yes, this was my mistake, thank you so much!!! :smiley:

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.