Default columns - Cloud - 8.0

Phone number standardization

Version
Cloud
8.0
Language
English (United States)
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Standardization components > Phone number standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Phone number standardization components
Design and Development > Third-party systems > Data Quality components > Standardization components > Phone number standardization components

The following table presents details about the default columns provided by tStandardizePhoneNumber.

Tip: In addition to these default columns, you need to define more columns alongside in order for this component to receive the corresponding input data.

Columns

Description

StandardizedPhoneNumber

This column presents the standardized phone numbers.

IsValidPhoneNumber 1

This column indicates whether a phone number processed is recognized as valid.

IsValidPhoneNumberForRegion 2

This column indicates whether a phone number is recognized as valid for a certain region.

IsPossiblePhoneNumber

This column indicates whether a phone number processed is supposed to be valid.

IsAlreadyStandard

This column indicates whether a phone number processed is already standardized after comparing it with the output standardized phone number.

PhoneNumberType

This column indicates the type of a processed phone number, such as fixed line, toll free, etc.

ErrorMessage

This column presents the relative error message if a phone number is unrecognizable.

1 As IsValidPhoneNumberForRegion was added from 7.3 onwards, when you run a Job created in a previous version, the results in IsValidPhoneNumber may be different than the previous versions.

2 From Talend Studio 7.3, when you use a Job created in a previous version, you do not have this column.

1, 2 These columns can have the same input data but the results are different. For example: A phone number is valid, true returned in IsValidPhoneNumber, but the country code is wrong, false returned in IsValidPhoneNumberForRegion.