Column to row for selected columns

KNIME Analytics Platform
1

Hi,

I’m trying to transform a table. It starts off with a key column and then three sets of columns. Each set contains an Import column and a Value column.

I’d like to transform this table so that there is only one Import and Value column, as per the attached images. Is this possible in KNIME?

image

image
image202×556 5.75 KB

2

Hey there,

it is definitely possible and there will be many different ways to get to that result.

I’ve chose to Unpivot the dataset, then to group into Type Import or Type value and then to Pivot again:

image
image2166×546 22.2 KB

I just used one of your rows (do not enjoy typing data manually a lot…)

Workflow:
unpivotexample.knwf (78.4 KB)

3 Likes
3

Martins Solution is already brilliant, but as he said there are many ways to get the result. Mine is the following:

image
image738×376 50 KB

2 Likes