transpose particular columns to rows

KNIME Analytics Platform
1

hii,
First table is how my data looks like and second table what i want to do
TABLE:1
year stud1 stud2
2013 78 88
2015 67 77
TABLE:2
year name marks
2013 stud1 78
2013 stud2 88
2015 stud1 67
2015 stud2 77
how to perform in KNIME?

1 Like
2

Hi!

Yes there is. It is Unpivoting node for transformation. Then use Colunm Rename node to get column names you wish.

Br,
Ivan

2 Likes
3

Thanks ,
Its Working fine…

4

But unpivoting takes too much time to execute…in source i have 1 million data,it takes more time to execute in unpivot node…
using excel writer i am not able to write the data in excel…
Is there any solution??

Thanks for help,

5

Correct. Unpivoting takes time. 1 million rows? How long does it last?
What’s error you get?
Ivan