Collapse all cells in columns to a single column

KNIME Analytics Platform
1

I have a single table with the following format:

| | Turn 1 | Turn 2 | Turn 3 |
| Row 1 | JSON | JSON | JSON |
| Row 2 | JSON | JSON | JSON |

I want to convert it into the following format:

| | Turn |
| Row 1 | JSON |
| Row 2 | JSON |
| Row 3 | JSON |
| Row 4 | JSON |
| Row 5 | JSON |
| Row 6 | JSON |

How can I achieve this? I have been looking at the Column Appender but it seems to require 2 separate tables.

2

Managed to sort this by using Column Aggregator node with Ungroup.

Column Aggregator should have “List” as the aggregation type (under “options”), and “Remove aggregation columns” selected.

Ungroup then splits the list into rows.

1 Like
3

Right, I was providing a workflow in which I solved the issue by using a “Transpose” node in a loop. This yields exactly the structure you asked:
collapse cells.knwf (30.8 KB)

I have also added your own solution to the workflow.

Best,
Armin

3 Likes
4

Great, thanks Armin!

2 Likes