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 ?
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
