Transforming data in columns - Cloud

Talend Cloud Data Stewardship User Guide

Talend Cloud
Talend Data Stewardship
Administration and Monitoring > Managing users
Data Governance > Assigning tasks
Data Governance > Managing campaigns
Data Governance > Managing data models
Data Quality and Preparation > Handling tasks
Last publication date
When handling tasks in a Resolution or Merging campaign, data stewards can use a list of different functions on a given column in the task list and do a bulk transformation of the data in the selected column.


  1. On the Tasks page, click the name of the campaign you want to open.
  2. From the task list, select the heading of the column for which you want to do the bulk modification.
    The column name is displayed at the top of the right panel and all available functions are listed under Column.
  3. Browse the list to reach the function you want to use on the column data, or type the function name in the search field.
    In this example, phone numbers are not conformed to the general format of the international phone numbers.
  4. Expand Format phone number and:
    1. From the Region code list, select American standard.
    2. From the Format type list, select E164.
  5. Click Submit.
    When you use functions on columns in a Merging campaign, only values in the master fields are transformed, i.e. values in the source fields are not


Phone numbers in the column are transformed to conform to the general standard of the American phone numbers.