JupyterLab Extension for INFACore

Back Next

Get country ISO values

You can apply this function to your data to standardize country names to their respective country codes.

To perform this operation, select the

Get Country ISO Values

function, and specify the data object variable. Then, enter the name of the country column for which you want the ISO values.

The function reads the input country name and returns the full ISO country name and their respective ISO two-letter or three-letter country codes.

In the following example, the input flat file includes a column named country and contains the following data: India, XYZ, and 123!.

The following example is the input code snippet when you apply the function::

import informatica.infacore as ic
FF_DV = ic.get_data_source("Flat File").get_connection("DR_FlatFile").get_data_object("input.csv")
dqf = ic.DataQualityFunctions()
dqf.get_country_iso_values(FF_DV,"country")

The following snippet shows the output:

Out_Country_Name: string
Out_Country_ISO2Char: string
Out_Country_ISO3Char: string
----
Out_Country_Name: [["INDIA","XYZ","123!"]]
Out_Country_ISO2Char: [["IN","XYZ","123!"]]
Out_Country_ISO3Char: [["IND","XYZ","123!"]]

Rename Saved Search

Table of Contents

JupyterLab Extension for INFACore

JupyterLab Extension for INFACore

Get country ISO values

Get country ISO values