Cell to divide into rows

Hello everyone.
I would like to divide this cell into 3 different rows. Every time the word “Raccolta” is repeated in this column, I need to generate a new row. How can I do that?

Hello @MGDiNicola , and welcome to the KNIME community.

Please take a look into the following topic:

I hope this help for your use case.

BR

1 Like

Thanks for your kind response.
I think I don’t know how to correctly configure the cell splitter node because I always get the same result

Hi @MGDiNicola
It’s an old post. I’ll try to find the associated workflow to share. Let me…

Otherwhise you can share some sample data to test. A couple of cells and columns may be enough.

BR

1 Like

Hello @MGDiNicola
I’ve prepared an upgraded workflow, aiming to achieve text processing to multiline cells within a data frame.

Let me know your thoughts.

BR

2 Likes

Hi,
I’ll send you a sample file. In the first sheet there are the data to be processed in knime. In the second sheet, the expected output.
Can I see how the nodes are configured for processing?
Prova KNIME.xlsx (19.0 KB)

Thanks.

Hello @MGDiNicola
I’ve upgraded the workflow with your input data.

Please check! You should download it back again from KNIME HUB

BR

2 Likes

Great! Perfect!
Thank you!!

2 Likes

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