Split a cell and add the split data in to rows

Hi,

I have a table which looks like this below picture;
image

And I want the output like below;
image

Please suggest Nodes or reply with workflows

Appreciate the effort in advance.

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

5 Likes

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

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?

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

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

3 Likes

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