How to Normalize Country Names to ISO Codes

Task

The supplier file uses country names such as Germany, Spain, and France. The output table needs short ISO codes.

Short answer

Create country_code from country and add replacements: Germany → DE, Spain → ES, France → FR.

How to Do It in Eofferix

1. Open the settings of the output country_code column.

   

2. In Transformations, add one Equal → Replace with rule for each country.

   

3. Save the column settings and go to the Export step.

Before / After