Categorical values to columns

[RapidDuck]

Hello,
I have this table:

I want to display these values in a heatmap. For this I need them differently arranged.

I need the ages as RowIDs, the severities from 0-11 as columns and Row Percent as values. Like this:

But I can’t find a node that can do that.

Thanks
Eric

[gonhaddock]

Hello @RapidDuck and welcome to the KNIME community

Your node is ‘Pivoting’

BR

[elsamuel]

Welcome to the forum @RapidDuck

The node you’re looking for is the Pivoting node. You’d group by Age, Pivot on Severity, and Aggregate by Row Percent using First.

[gonhaddock]

Hi @elsamuel
Without knowing the data in advance. I would suggest an aggregation by Mean.

@RapidDuck, explore your Output for the desired results.

BR

[RapidDuck]

Thanks to you both. Worked perfectly!