How to transpose/pivot only a single column

[SirTobi]

Hello everybody,

this is my first post in this forum and I really hope that I am doing everything according to the guidelines I have an issue that I cannot seem to solve myself and could not find the soulution in this forum. So, I hope that somebody is able to help me:

I have a database where there are several datasets for products. These datasets only differ in their “Amount used” value while per product, the values “Product” and “Sugar?” are always the same:

Now I would like to transpose the “Amount used” column, so that I only get one column per value and only end up with two datasets:

I played around with the pivot node but it seems that I cannot get the settings right and I am not even sure that it is the correct node to use, since I don’t want to aggregate any values.

Thanks a lot!

Cheers,
Tobi

[ArjenEX]

Hi @SirTobi

Welcome to the KNIME community!

A way to approach this is to use a GroupBy based on Product and Sugar. This way, you can create a list of Amounts that you can split to individual columns subsequently.

Note: for reference I kept the original list in there. You can also opt to have it removed in the Cell Splitter node.

WF: How to transpose pivot only a single column.knwf (28.6 KB)

Hope this helps.

[SirTobi]

Yes, it works perfectly!! Thank you so much!!