Unpivot Data Nodes

Hi All,

Is there a node that can convert my sample input data below.

Sample Input Data
Key Name Product Region A_v1 B_v1 C_v1 A_v2 B_v2 C_v2 A_v3 B_v3 C_v3
890 Mark Cabinet ID 15 25 28 33 35 42 43 50 51
567 Joshua Printer KR 20 30 33 38 40 47 48 55 56
234 MJ Mouse PH 25 35 38 43 45 52 53 60 61
Sample Output Data
Key Name Product Region A B C Version
890 Mark Cabinet ID 15 25 28 1
567 Joshua Printer KR 20 30 33 1
234 MJ Mouse PH 25 35 38 1
890 Mark Cabinet ID 33 35 42 2
567 Joshua Printer KR 38 40 47 2
234 MJ Mouse PH 43 45 52 2
890 Mark Cabinet ID 43 50 51 3
567 Joshua Printer KR 48 55 56 3
234 MJ Mouse PH 53 60 61 3

Respectfully,
Sean

Hoi @seanmanzanilla

In this solution you both an Unpivoting node an a Pivoting node, see
Unpivot Data Nodes.knwf (29.7 KB)
image
gr. Hans

2 Likes

Hi @seanmanzanilla -

I have moved your topic, but in the future please post workflow questions in the main Analytics Platform forum instead of the KNIME Development forum. Thanks!

2 Likes

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