JupyterLab Extension for INFACore

Back Next

Validate the United States counties

You can apply this function to validate if the input string is a valid county name in the United States.

To perform this operation, select the

Validate US County

function, and specify the data object variable. Then, enter the column name that contains the county names that you want to validate.

When you run the code, the function validates if the county name is valid.

For example, the input flat file includes a column named county that contains the names of the Unites States counties.

The following snippet is the input code 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.validate_us_county(FF_DV,"County")

The following snippet shows the output returned with the validation values for the counties:

County: string
County_Status: string
----
County: [["Jackson County","Marion","Clay"]]
County_Status: [["Invalid","Valid","Valid"]]

Rename Saved Search

Table of Contents

JupyterLab Extension for INFACore

JupyterLab Extension for INFACore

Validate the United States counties

Validate the United States counties