Cell to divide into rows

[MGDiNicola]

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?

[gonhaddock]

Hello @MGDiNicola , and welcome to the KNIME community.

Please take a look into the following topic:

Mulit-line string input into table

Hi @kienerj I’m not sure that I fully understood your your request. An example of input → aimed output would help… [image] Do you have a multi-line text in a cell like this one? [image] And you want to split it in rows. Or do you have a text split in rows? ‘Cell Splitter’ node delimiter == "\n" Then Unpivot [image] Then, do you want to merge it in a cell? ‘Pivoting’ ‘Column Aggregator’ node columns, wildcard == "*_Arr*" concatenate, delimiter == "\n" [image] BR

I hope this help for your use case.

BR

[MGDiNicola]

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

[gonhaddock]

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

[gonhaddock]

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

Data Wrangling _ Multi-line_Text_to_Multi-row – gonhaddock

Let me know your thoughts.

BR

[MGDiNicola]

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.

[gonhaddock]

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

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

BR

[MGDiNicola]

Great! Perfect!
Thank you!!