JupyterLab Extension for INFACore

JupyterLab Extension for INFACore

Validate names

Validate names

You can apply this function to flag suspicious or fake names in the source data.
To perform this operation, select the
Find Invalid Names
function, and specify the data object variable. Then, enter the column name that contains names that you want to validate.
When you run the code, the function validates the names.
For example, the input flat file includes a
Name
column that contains control characters.
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.find_invalid_names(FF_DV,"Name")
The following snippet shows the output, where the function flags the names that are valid and those that are suspected:
Name: string Validation_Status: string ---- Name: [["Arcane","Aquata","ARTHUR M LYNCH JR"]] Validation_Status: [["Valid","Suspect","Valid"]]

0 COMMENTS

We’d like to hear from you!