Splitting a single row into more based on special character

KNIME Analytics Platform
1

Hi.
I am new with Knime and hope someone can help me.
I have a single row of data as follows (example). First row represents the columns and second row the data.

Row0 Row1 Row2 Row3 Row4 Row5 Row6 Row7 Row8 Row9
AA BB CC ^ DD EE FF ^ II JJ

I would like to break this single row into many delimited by the character "^", as follows.

Row0 Row1 Row2
AA BB CC
DD EE FF
II JJ  

Any help would be welcomed.

Thanks in advance.

Best regards,

 

2

Hi,

you can do this with the comibination of column combiners, splitting, unpivoting and another splitting. I will attach the workflow which demonstrates my idea.

Best, Iris