Image 1:
Image2:
Here is my case,
I would like to change the data fromat from image 1 to image 2.
Also, I would like to do is that when there is asian country, input Asia in continent Column.
How can I do it through Knime?
Many Thanks!
Image 1:
I would like to change the data fromat from image 1 to image 2.
Also, I would like to do is that when there is asian country, input Asia in continent Column.
How can I do it through Knime?
Many Thanks!
Hi @HKuser,
the node which converts your date columns to rows is called “Unpivot”.
In order to assign the continent, I suggest to use a second assignment table. If your list of countries is too big, I’m sure the web will provide a csv as external data for that.
Check this workflow…
Hope, this helps, Greetz,
Tommy
Many Thanks! It works!!!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.