Reading client data from an Excel file

Imagine your company is a provider of movie rental and streaming video services.

In the examples described in this chapter you have to cleanse a file containing data about your customers, such as their names, age, contact details, subscription dates or numbers of rentals. You want to make this data clearer and easier to work with.

The examples provided in this chapter assume that you are registered in Talend Management Console as a Talend Cloud Data Preparation user. For more information, see Talend Cloud Data Preparation.

This scenario describes a variety of actions that you can perform on your client file to remove or correct inconsistencies and improve the quality of your data.