Transforming data in a column - 7.0

Talend Data Stewardship User Guide

Version
7.0
Language
English (United States)
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
Installation and Upgrade
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.

Before you begin

  • A campaign owner has defined you as part of a Resolution or Merging campaign.
  • A campaign owner has assigned you tasks in the campaign. Otherwise, you can assign the tasks to yourself.

    For further information, see Assigning tasks as a data steward.

Procedure

  1. On the TASKS page, click the name of the campaign you want to open.
  2. In the task list, click 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. For further information about the functions in the right panel, see List of functions on columns.
  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.