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

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.

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)
Schermafdruk van 2021-09-09 21-45-47

gr.Hans

4 Likes

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

1 Like

Thank you,
Works great!

2 Likes

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