Harmonizing the case - 2.0

Talend Data Preparation Getting Started Guide

Talend Documentation Team
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
Data Quality and Preparation > Cleansing data
Talend Data Preparation

The first action will be to fix the column listing the first names of the customers.

You can notice that in the customers.xlsx file, there are some inconsistencies among the names in the FIRST_NAME and LAST_NAME columns. Some begin with a capital letter, some are entirely in lower case, and others are entirely in upper case.

To harmonize the style of all the cells of a column, proceed as follows:


  1. Click the header of the FIRST_NAME column to select its content.
  2. In the upper right side of the screen, find Change Style to Title Case in the list of functions.

    This box lists all the functions available to apply on your data. Search for the function you want, or choose among the suggested ones. Hover over a function in the list to preview the effect it will have on your data. Click the function to apply the changes.

  3. Click Change Style to Title Case to apply the function on the column.

    All the first names now begin with a Capital letter, with the rest in lower case.

  4. Repeat those steps on the LAST_NAME column to harmonize the customers last names.