Harmonizing the case - Cloud

Talend Cloud Data Preparation Getting Started Guide

Version
Cloud
Language
English
Product
Talend Cloud
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data
Last publication date
2024-03-05

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:

Procedure

  1. Click the header of the First_Name column to select its content.
  2. While pressing the Ctrl key, click the header of the Last_Name column.
    The two columns are now selected and you will modify them both at the same time.
    Two columns selected.
  3. In the Functions panel located in the upper right side of the screen, find Change to title case in the list of functions and click it.
    Change to title case function.

    This box lists all the functions available to apply on your data. Search for the function you want, or choose among the suggested ones. Use the Preview button to see the effect it will have on your data.

  4. Click Submit to apply the function on the two columns.
    All the names now begin with a capital letter, with the rest in lower case.
    Two columns selected.