Split a cell and add the split data in to rows

[Braveen]

Hi,

I have a table which looks like this below picture;

And I want the output like below;

Please suggest Nodes or reply with workflows

Appreciate the effort in advance.

[piotr_domagala]

See attached workflow.
Hope it helps.
Regards
PiotrKNIME_project2.knwf (20.5 KB)

[Braveen]

You are the best, Piotr. Thank you so much.

[Braveen]

Also, Can you suggest me a node or how do I split the cell using multiple delimiter?

eg: v1,v2,v3;v4,v5

I can repeat the nodes to achieve this. but in single node, can I give multiple delimiters?

[piotr_domagala]

I think that there is no multiple delimiter in cell splitter.
Only way I know needs repeating.
Cheers
Piotr

[ipazin]

Hi @Braveen,

you can use String Manipulation node to replace all comma chars with semi colon or vice versa to have only one delimiter.

Br,
Ivan