Working with the quality bar - 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 quickest way to identify incorrect data is to look at the quality bar.

Under each column is a quality bar that displays the number of fields that have correct data, incorrect data or empty fields. Each category is represented by a color:

  • Green for data that matches the cell format
  • Grey for empty cells
  • Red for data that does not match the cell format

Click any color to select, delete, or clear the cells with data in an invalid format. Hovering over the colors allows you to display the exact number of lines for each category, as well as the percentage it represents in a column.

By looking at the quality bar under in the Email column header, you can see that there are empty cells and incorrect values among the data. You are going to remove them.

Quality bar under the Email column with a gray part signaling there are empty cells and a red part signaling there are incorrect values.

To use the quality bar to remove the lines containing those incorrect cells, proceed as follows:

Procedure

  1. Click the gray part of the quality bar, in the header of the Email column.
    A drop-down menu opens.
    Drop-down of the Email column gray part.
  2. Click Delete the rows with empty cells.
    The empty cells of the Email columns have been deleted and only the invalid values, represented by the red bar, remain.
    Only invalid values left in the Email column.
  3. Repeat the last two steps, but this time, click the red part of the quality bar, and select Delete the rows with invalid cells.
    The Email column is now cleaned of all invalid data or empty cells.
    The Email column has only valid values left.
  4. Use the quality bar to remove the invalid cells from the Zip and Phone columns.

Results

The only remaining column with invalid data is now State, but you are going to treat it in a different way.