# Generating a Job to standardize phone numbers

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
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
* Real-Time Big Data Platform

When you use the Profiling perspective of Talend Studio to analyze phone numbers in a database, you can later generate a ready-to-use Job that will give a correct format to the phone numbers in the specified column.

For further information on phone number indicators, see [Phone number statistics](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/phone-number-statistics).

## Before you begin

A column analysis on phone numbers has been created and executed in the Profiling perspective of Talend Studio. For detailed steps on how to create a column analysis, see [Defining the columns to be analyzed](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2025-02/defining-columns-to-be-analyzed "The first step in analyzing the content of one or multiple columns is to define the columns to be analyzed. The analysis results provides statistics about the values within each column.").

## Procedure

1. From the Profiling perspective, set Phone Number Statistics indicators on the specified column that holds phone numbers.
2. Execute this analysis to open the results in the Analysis Results view.

   ![Table and graphic for the Phone Number Statistics indicator.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/column_analysis_standardize_phone_numbers.png)
3. In the Phone Number Statistics table and in the Count list, right-click Valid Phone Number Count, Possible Phone Number Count or Well formed National Number Count and then select Generate a standardization phone number job from the contextual menu.

   The Integration perspective opens in Talend Studio showing the generated Job with the tStandardizePhoneNumber component. For more information on this component, see [its documentation](https://help.qlik.com/talend/en-US/components/8.0/phone-number-standardization/tstandardizephonenumber).

   ![Job using the tMysqlInput, tStandardizePhoneNumber, and tFileOutputExcel components.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/column_analysis_standardize_phone_numbers1.png)

   A node for the newly generated Job shows as well under the Job design folder in the Repository tree view of the Integration perspective.

   In the generated Job, the input and the tStandardizePhoneNumber components are already configured according to the connection you use for the column analysis and according to the column you are analyzing.

   The output component is a file component, but you can replace it with a database output component to write the standardize phone numbers directly in a specific database, for example.
4. Decide the format to be used to standardize the phone numbers:
   1. Double-click the tStandardizePhoneNumber component to open the Component view.
   2. From the Phone number format for output list, select the format according to which you want to standardize the phone numbers in the selected column.
   3. Save your changes.
5. Configure the output component:
   1. Double-click the output component and in the File Name field, set the path to the output file that will hold the phone number analysis results.
   2. In the Sheet Name field, set the name of the excel sheet in which you want to write the standardization results.
   3. Save the Job and press F6 to execute it.

      The phone number standardization results are written to the specified excel sheet.
   4. If required, right-click tFileOutputExcel in the generated Job and select Data Viewer.

      A preview of the standardized data is open in the Talend Studio. ![Overview of a preview of analyzed data.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/column_analysis_standardize_phone_numbers3.png)