Pivot/unpivot question

KNIME Analytics Platform
1

Hi,

I have this top table in the screenshot that I would like to have in the format of the bottom table. I’m not able to figure this out. I tried with unpivot, but it’s not resulting in the right output. Any ideas?

The ‘issue’ is that the company names are the columns names, while they should become row data values, while the values in those columns should be be all in one column.

image
image457×637 9.94 KB

2

Hi,

“unpivot” is the node to go for :slight_smile:

Here are the settings of the node:

image
image488×1196 75.7 KB

5 Likes
3

Wow, great. So it was a lack of knowledge from my side how to use the unpivot node! Thank you so much!

2 Likes
4

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