Transforming data in columns - 7.3

Talend Data Stewardship User Guide
Version
7.3
Language
English
Product
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
Module
Talend Data Stewardship
Content
Administration and Monitoring > Managing users
Data Governance > Assigning tasks
Data Governance > Managing campaigns
Data Governance > Managing data models
Data Quality and Preparation > Handling tasks
Data Quality and Preparation > Managing semantic types
Last publication date
2023-09-19
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.

Procedure

  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

Results

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