Combining columns

You can create new values in the incoming data by combining values from the existing columns. For example, you might combine an "Area Code" column and "Local Number" column to create a "Full Telephone Number" column.

About this task

You combine columns by adding a new column, choosing which existing columns to combine, and specifying how to combine them. User-defined data columns are identified in the data preview table with a highlight color.

Procedure

To merge columns:
  1. On the Column Actions page, click New.
    The New Column window is displayed.
  2. Enter a name in the Enter the name of the new column field.
    For example, you might enter "Full Telephone Number".
  3. From the Source Columns list, double-click a column or a separator to add it to the Joined Columns list.
    The Joined Columns list specifies the columns and separators that are used in the new column, and the order that they are used in.
    For example, you might combine an "Area Code" column and a "Local Number" column and separate them with a space:
    1. Double-click "Area Code" in the Source Columns list.
    2. Double-click (space).
    3. Double-click "Local Number".
  4. To change the position of a column or separator in the new column, select the column or separator in the Joined Columns list and click Up or Down.
  5. Click OK.
    The new column is created.