Matrix Table View

Hi! I would like to create a matrix table.
The way my table looks right now is like this
image

But I want a view like this, where the columns are grouped by cycle. I only need it for a view so not to do more transformations after.

image

Anyone have any ideas? Thanks! :slight_smile:

Hi @erikawalther

Go for the Pivot node.
Group Column(s) = Label
Pivot Column(s) = Cycle
And Manual Aggreation see below

gr. Hans

4 Likes

Hello @erikawalther
The solution seems to be: unpivot the parameters. Then merge unpivoted column header with โ€˜Cycleโ€™ column. And finally pivot back again the nested column header; as there isnโ€™t a hierarchical column header option in KNIME.

Regards

1 Like