Which node to use for this?

KNIME Analytics Platform
1

Hello, 

I want to create a new column called "Continent" out of an existing column called "Country"

e.g. when find (Austria) in column "Country" then Column "Continent" should have (Europe)...

Since I have 100+ countries I need to find a way how to write the expression and which node to use to create "Continent" column.

Thanks
Sam

2

anyone? I thought it was gonna be very straight forward but is not the case!

3

It is straight forward using the Cell Replacer node :-)

4

Yes the cell de placer node work like a vlookup

5

well for cell replacer node two inputs/tables are needed while I am talking about just one data table. How to do it for just one data table input?

6

And if you connected twice the same table?

7

Hi Sam,

you have one table which has the Country, but not the continent?

And you want to change this country to the continent?

Than you need an configuration table containing County and Continent and this will be the second import of the cell replacer node.

Those lists are available online, e.g. this one http://www.countries-list.info/Download-List/download

 

Best, Iris

8

Or you could use a Joiner, but you still need a lookup table with the country-continent pairs

Steve
 

9

Excellent Iris... many thanks to you...