Phone number statistics - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-03-28
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

Indicators in this group count phone numbers. They return the count for each phone number format. They validate the phone formats using the org.talend.libraries.google.libphonumber library.

  • Valid phone number count: computes the valid phone numbers.
  • Possible phone number count: computes the supposed valid phone numbers.
  • Valid region code number count: computes phone numbers with valid region code.
  • Invalid region code count. computes phone numbers with invalid region code.
  • Valid phone number for region count: computes the phone numbers that are recognized as valid for a certain region.
  • Well formed national phone number count: computes well formatted national phone numbers.
  • Well formed international phone number count: computes the international phone numbers that respect the international phone format (phone numbers that start with the country code) .
  • Well formed E164 phone number count: computes the international phone numbers that respect the international phone format ( maximum of fifteen digits written with a + prefix.
  • Format Phone Number Frequency: shows the results of the phone number count in a pie chart divided into sectors.

The following table shows the indicators that you can select in any database:

Indicator Supported data types with the Java analysis engine Supported data types with the SQL analysis engine
Valid Phone Number Count
  • Number
  • Text
  • Date
None
Valid Region Code Count
  • Number
  • Text
  • Date
None
Invalid Region Code Count
  • Number
  • Text
  • Date
None
Valid Phone Number for Region Count
  • Number
  • Text
  • Date
None
Possible Phone Number Count
  • Number
  • Text
  • Date
None
Well Formed International Phone Number Count
  • Number
  • Text
  • Date
None
Well Formed National Phone Number Count
  • Number
  • Text
  • Date
None
Well Formed E164 Phone Number Count
  • Number
  • Text
  • Date
None
Format Phone Number Frequency
  • Number
  • Text
  • Date
None
Tip: When using Valid Phone Number for Region Count and Valid Phone Number Count with the same input data, the results might be different. For example, a phone number is valid, so true is returned in Valid Phone Number Count, but the country code is wrong, so false is returned in Valid Phone Number for Region Count.