Applying a value to all cells - 7.3

Talend Data Preparation Getting Started Guide

Version
7.3
Language
English
Product
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
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data
Last publication date
2023-01-05

Applying a certain value to many cells at once can save you a lot of time when correcting invalid cells.

The State column is the last column containing incorrect data. This column lists the States from which the customers have rented a movie, using a two-letter code. You can notice that among all the other US state codes, the occurrences of Texas stand out as errors.

Rather than simply deleting the corresponding lines with the quality bar like you did before, you are going to correct one of the invalid cells, and apply the new value to all the cells with the same error. To replace the occurrences of Texas with the correct value, proceed as follows:

Procedure

  1. In the State column, double-click one of the occurrences of Texas.

    You can now edit the content of the cell, and a menu with a check box opens.

  2. Instead of Texas, type TX, which is the correct two-letter code.
  3. Select the check box Apply to all cells with this value.
  4. Press the Enter key.

Results

All the occurrences of Texas have been replaced by the correct TX State code and the quality bar now indicates that all the data in the State column is correct.

Note that when the State column is selected, the data is visualized in the form of an interactive map of the United-States in the Data profiling panel.