Feed a new table from rows data

Hello everyone,

I’m super new to Knime but so far I’m having a blast. I’m doing some brainstorming here and would like to re-organize a table I already have in a different way but I’m not sure how to do so.

This is a random example of what I want to achieve: to transform the data of the blue table into the green one:

Could any kind soul point me to the right direction?

Thanks a million in advance!


Hi @Arkymedes

This is something for the Pivot node. See pivot_example.knwf (19.3 KB)
Groups => city
Pivots => type
Manual Aggregation => qty & code

gr. Hans


Hello @HansS

That was perfect. It completely escaped my mind the use of Pivot tables…

Thanks again and have a great week.


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.