Convert two-letter country/language code to formal country name

[knozawa]

Hello,

I would like to convert two-letter country code into formal country name.

Sample:

BR --> Brazil

IT --> Italy

US --> United States

Is there any simple way?

Thank you,

Kazumi

[dataMack · Accepted solution]

1. Find a table with the listings of name and abbreviation (here's one I just found - http://www.nationsonline.org/oneworld/country_code_list.htm)

2. Copy and paste that into a 'Text Input' tool in Alteryx

3. Use the "Find/Replace" tool (under the join category) and connect it to your source data and the Text input tool with the table you copied in.

4. Set the Find Replace tool to take the full country name from a match on the abbreviation field.

[knozawa]

Thank you very much!

[Jens1245]

You can use www.countryconversion.com

[ijkiv]

I also found this list, which I found useful https://www.iban.com/country-codes 

[Myra01]

Hi,

I tried to do in this same way, but still doesn't work, so can you please help me have a look?