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
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
Thanks ,
Its Working fine…
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,
Correct. Unpivoting takes time. 1 million rows? How long does it last?
What’s error you get?
Ivan