# Talend Cloud Data Preparation Examples

The use cases described in this document show several way of using Talend Cloud Data Preparation to perform formatting or cleansing operations to your data.

From the guided tour embedded in the application, you can import several demo datasets, as well a demo preparations that were created on top of them to get a first idea of the improvements you can make to the overall quality of your data:

* The Customers dataset is used as source for the Standardize preparation. It shows how you can standardize state names, delete invalid records, consolidate phone numbers, change their format as well as date formats, or use a masking function to protect data. Finally, the Magic Fill function is used to convert dates to the corresponding day of the week.
* The Build\_email preparation uses the Marketing Leads and the Emails Reference datasets and joins them in order to recreate emails addresses from customers names, company names, and their corresponding domain addresses.

In addition to these preparations that are available directly in the application, you can download additional datasets and use them to complete the following examples:

* Based on the [](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/CRM_export.csv)[CRM_export.csv](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/CRM_export.csv) dataset, build a preparation to consolidate in a new column all the mobile phones or landline phone numbers of your customers to make sure you have at least a working number for each.

  See [Consolidating a list of phone numbers coming from a CRM solution](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/consolidating-list-of-phone-numbers-coming-from-crm-solution "The CRM Export dataset corresponds to an Excel file that has been exported from a CRM solution.").

* The [](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/marketing_leads.zip)[marketing_leads.zip](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/marketing_leads.zip) and [](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/emails_reference.zip)[emails_reference.zip](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/emails_reference.zip) datasets can be used together in the same preparation via a lookup operation to join the information about companies domain addresses and recreate entire email addresses.

  See [Recreating email addresses before uploading them to a marketing solution](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/recreating-email-addresses-before-uploading-them-to-marketing-solution "The Marketing leads dataset represents a file you received from a marketing campaign but the email addresses are missing.").

* With the [](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/HRMS_export.xlsx)[HRMS_export.xlsx](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/HRMS_export.xlsx) dataset, learn how to change date formats and extract specific strings of characters from any column.

  See [Cleansing data coming from a human resource management system](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/cleansing-data-coming-from-human-resource-management-system "The HRMS Export dataset corresponds to an Excel file that has been exported from an American human resource management system (or HRMS).").

* The [](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/customer_contact_data.csv)[customer_contact_data.csv](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/customer_contact_data.csv) dataset can be improved by cleaning the empty and invalid datasets, and removing unnecessary blank spaces in text records.

  See [Preparing client data to upload it to a marketing solution](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/preparing-client-data-to-upload-it-to-marketing-solution "The Customer Contact Data dataset represents a file containing a list of clients with different information such as their name, their company or their country.").

* With the [](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/video_customers.xlsx)[video_customers.xlsx](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/video_customers.xlsx) dataset, follow a scenario to combine filters and create "if" conditions to isolate the data on a specific customers group.

  See [Using filters to create "if" conditions on customer data](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/using-filters-to-create-if-conditions-on-customer-data "The video_customers.xlsx dataset contains a sample with several information about the US customers of a video streaming company. Names, states, ages and subscription dates, among others, are listed in this file.").

* The [](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/car_dealership.xlsx)[car_dealership.xlsx](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/Content/Resources/attachments/car_dealership.xlsx) dataset is used as base for a preparation illustrating how to use regular expression to match data that cannot be selected with usual filters.

  See [Using regular expressions and filters to create "or" conditions on customer data](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/using-regular-expressions-and-filters-to-create-or-conditions-on-customer-data "The car_dealership.xlsx dataset contains information about the customers of a worldwide car dealership company, with relevant categories such as their names, driving experience, car manufacturer, model and year, or the city where the car was bought.").

### In this section

* [Consolidating a list of phone numbers coming from a CRM solution](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/consolidating-list-of-phone-numbers-coming-from-crm-solution)
* [Recreating email addresses before uploading them to a marketing solution](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/recreating-email-addresses-before-uploading-them-to-marketing-solution)
* [Cleansing data coming from a human resource management system](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/cleansing-data-coming-from-human-resource-management-system)
* [Preparing client data to upload it to a marketing solution](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/preparing-client-data-to-upload-it-to-marketing-solution)
* [Using filters to create "if" conditions on customer data](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/using-filters-to-create-if-conditions-on-customer-data)
* [Using regular expressions and filters to create "or" conditions on customer data](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/using-regular-expressions-and-filters-to-create-or-conditions-on-customer-data)
* [Improving the Talend Trust Score™ of a dataset using Talend Cloud Data Preparation](https://help.qlik.com/talend/en-US/data-preparation-user-guide/Cloud/improving-trust-score-of-dataset-using-talend-cloud-data-preparation)