Change table format from data in cell

[iCFO]

How to split multiline cells

Hi @kowisoft, I’ve had a look and uploaded my proposed solution here: Multiline-Cells v4-Alex – KNIME Community Hub. I kept your workflow and added mine underneath. What I am doing: I split the table so that only the Sales columns go into the loop. The rest I split off and add later again. I add an ID column to keep track of which row something belongs to, because in-between I use Ungroup, which may generate multiple rows from one row. Then I loop through the sales columns and split each val…

Take a look at this thread.

I always view the hidden return characters with online viewer sites like below first to pinpoint the specific Unicode line return.

https://www.soscisurvey.de/tools/view-chars.php