Consolidating a list of phone numbers coming from a CRM solution - 7.1

Talend Data Preparation Quick Examples

Talend Big Data
Talend Big Data Platform
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
Talend Data Preparation
Data Quality and Preparation > Cleansing data
Note: Talend Data Preparation has its own versioning. With 7.1, the corresponding version of Talend Data Preparation is 2.8.

The CRM Export dataset corresponds to an Excel file that has been exported from a CRM solution.

It contains a list of people with their phone numbers for both regular and mobile phones. As these phone numbers are French, they are 10 digits long; numbers starting with 01, 02, 03, 04, or 05 correspond to landline numbers and numbers starting with 06 correspond to mobile phone numbers.

In order to have a consolidated list of phone numbers to call, you will create a new column listing all the mobile phone numbers: this column will also be filled with the landline number when there is no mobile phone. Also, if the landline and mobile phone numbers have been mixed up, you will correct them.

Whereas in other tools you would use conditions like "if" to perform these actions, with Talend Data Preparation, you will create filters.

Retrieve the CRM_export.xlsx file from the Downloads tab in the left panel of this page.