Create new column based on column value.

Input dataset:

Categorical Data 1 Categorical Data 2 Numerical 1 Numerical 2
A X 1 2
A Y 3 4
A Z 5 6
B X 7 8
B Y 9 0
B Z 1 2
C X 3 4
C Y 5 6
C Z 7 8

Output needed:

Categorical Data 2 Numerical A1 Numerical A2 Numerical B1 Numerical B2 Numerical C1 Numerical C2
X 1 2 7 8 3 4
Y 3 4 9 0 5 6
Z 5 6 1 2 7 8
 

Please help. It is very urgent.

Hi jagajithmk,

You can do this using the Pivoting node, see the attached example.

Cheers,

Roland