Feed a new table from rows data

[Arkymedes]

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!

BR,
Joao

[HansS]

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

[Arkymedes]

Hello @HansS

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

Thanks again and have a great week.