Split cell comma separated string into new rows, keeping original data

[ADonciu]

Hi,

I have read a different topics and didn’t find the perfect solution for my issue. Want to separate each name in Shareholder column into new row and in the same time copying the data from original row.

From this :

To this:

Thank you so much in advance.

[HansS]

Hi @ADonciu , welcome to KNIME forum

I think the way to go is to split the Shareholders column (Cell Splitter) and then Unpivot your table. See KNIME_project.knwf (18.0 KB)

gr.Hans

[Daniel_Weikert]

I would use cell splitter and then ungroup the list
onetomany.knwf (7.4 KB)

[ADonciu]

Thank you,
Works great!