Hi! I would like to create a matrix table. The way my table looks right now is like this
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.
Anyone have any ideas? Thanks!
Hi @erikawalther
Go for the Pivot node. Group Column(s) = Label Pivot Column(s) = Cycle And Manual Aggreation see below
gr. Hans
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