Urgent! How to match a words to a large group through knime

Image 1:


Image2:
image
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!

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

5 Likes

Many Thanks! It works!!!

2 Likes

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