Replacing values with data from another column

Talend Data Preparation Quick Examples

author
Talend Documentation Team
EnrichVersion
6.5
2.3
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

You can take the data from any column, and use it to consolidate another.

Now that only the mobile phone numbers are selected, you will use these values to replace the wrong numbers in the Phone number to use column.

Procedure

  1. Select a column in which you want to replace values, Phone number to use in this example.
  2. In the Functions panel, type Fill Cells with Value and click the result to open the options for the associated function.
  3. Configure the function as follows.

    Make sure the Filtered Rows option is selected in order to only apply the function on the filtered lines.

  4. Click the Submit button to apply the function.

    The filtered content of the selected column, Phone number to use in this example, is replaced with the data from the Phone column.

  5. In the filter bar, click the garbage bin icon to clear the filter and display the whole dataset again.

Results

You have used the filtered data to update the information of the consolidated column.