Removing empty records from a column

Talend Data Preparation Quick Examples

author
Talend Documentation Team
EnrichVersion
6.5
2.3
EnrichProdName
Talend Data Services Platform
Talend Big Data
Talend Real-Time Big Data Platform
Talend Data Integration
Talend Data Fabric
Talend MDM Platform
Talend Big Data Platform
Talend ESB
Talend Data Management Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

The white part of the quality bar indicates that a column contains empty records. You may want to remove the rows containing these empty records.

In the quality bar, data that matches the column type is shown in green, while orange shows invalid data that does not match the column type.

Procedure

  1. In the top left of the grid, click the white arrow and select Display rows with empty values.

    This action applies a filter on all the empty entries from the dataset.

  2. In the functions panel, on the top right of your screen, type Delete these filtered rows and click the result to execute the associated function.

    All the rows containing empty cells are removed from the dataset.

  3. Click the bin icon in the filter bar to clear the filter and display the whole dataset again.

Results

All the rows containing empty records are removed from the dataset and the quality bar under each column is now fully green.