convert Country name to Country code

Anonymous — Tue, 10 Jul 2012 07:24:26 GMT

Ver: 5.1.1
Level : New
hi,
I have a input Access table with field "Land" containing country name. eg.
----------------
Land
----------------
France
Germany
United Kingdom
..
..
..
..
---------------
Now I would like to convert this to two letter international code in the new SQL database. So
---------------
France --> FR
Germany --> DE
United Kingdom --> UK
..
..
.. and so on.
---------------
I have the complete list for all countries.
I see that I can do it in tMap express builder. But its a over kill to write conditional statement like if = val:then:else for all countries.

Can any body suggest best way to handle this situation ?

Re: convert Country name to Country code

Anonymous — Tue, 10 Jul 2012 07:42:10 GMT

Hi
You'd better create a referrence table which contains two columns.
One is the entire country name(e.g. United Kingdom). The other is abbreviation (e.g. UK).
Then do inner join in tMap with the access table and this referrence table.
Regards,
Pedro

topic Re: convert Country name to Country code in Talend Studio

convert Country name to Country code

Re: convert Country name to Country code