tStandardizePhoneNumber Standard properties

Schema and Edit schema

A schema is a row description. It defines the number of fields (columns) to be processed and passed on to the next component. When you create a Spark Job, avoid the reserved word line when naming the fields.

This component provides default columns. For further information, see section Default columns.

Built-In: You create and store the schema locally for this component only.

Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs.

Phone number

Select the column holding the phone numbers of interest from the input data.

Country code

Select the column holding the country codes (ISO 2) from the input data.

Customize

Select this check box to set a custom country code (ISO 2). Once selected, it disables the Country code field and gives priority to the customized country code for phone number standardization.

For example, if the input data provides a set of phone numbers with a wrong country code or alternatively with no country code, then you can select this check box and type in the country code you need for standardization.

Phone number format for output

Select the format to be used to standardize the phone numbers of interest. The available options are:

- E164

- International

- National

Avoid comparison

Select this check box to deactivate the comparison performed between the input and the output data at runtime. This can accelerate the execution process of the Job using this component.

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at the Job level as well as at each component level.

Global Variables

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl+Space to access the variable list and choose the variable to use from it.

For more information about variables, see Using contexts and variables.

Usage rule

This component is usually used as an intermediate component, and it requires an input component and an output component.