Filling empty cells with data from another column - 2.0

Talend Data Preparation Quick Examples

author
Talend Documentation Team
EnrichVersion
6.3
2.0
EnrichProdName
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
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

The white part of the quality bar indicates that the column contains empty records.

You will fill the empty cells from the Phone number to use, with landline numbers extracted from the Phone column.

Procedure

  1. Select the Phone number to use column.

    You can identify columns containing empty records using the quality bar. The white part of it indicates that the column contains empty records. Data that matches the column type is shown in green, while orange shows invalid data that does not match the column type.

  2. In the functions panel, type Fill Empty Cells with Text and click the result to open the options for the associated function.
  3. Configure the function as follows.
  4. Click the Submit button to apply the function.

Results

The empty cells in the Phone number to use column are filled with data from the Phone column.