Filling empty cells with data from another column - Cloud

Talend Cloud Data Preparation Quick Examples

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data

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.