Skip to main content Skip to complementary content

Transforming data in columns

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!