Default columns - Cloud - 8.0

Phone number standardization

Version
Cloud
8.0
Language
English
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
Last publication date
2024-02-20

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 1

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 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.