transpose data

Hi all,
im not sure if this is a “transpose” problem but i’ve been trying diferent nodes for a while and i cant find a solution…

I have a data sheet with the following scheme:

code value1 value2 value3 value4
001 RED GREEN PINK BLUE
002 WHITE BLACK
003 WHITE RED YELLOW
004 BLUE

but i need to transform this table, to one like this:

code value
001 RED
001 GREEN
001 PINK
001 BLUE
002 WHITE
002 BLACK
003 WHITE
003 RED
003 YELLOW
004 BLUE

i’ve been serching in the forum too but i havent founded anything similar.

Please, anyone can help me?

Thanks!

Try the Unpivot node.

3 Likes

Thanks Aswin!!

that solved my problem

this is the configuration of the unpivoting node that i have used:

for getting this result:

code value
001 RED
001 GREEN
001 PINK
001 BLUE
002 WHITE
002 BLACK
003 WHITE
003 RED
003 YELLOW
004 BLUE

thank you so much

1 Like

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