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:
- On the Column Actions page, click New.
The New Column window is displayed.
- Enter a name in the Enter the name of the new
column field.
For example, you might enter
"Full Telephone Number".
- 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:
- Double-click "Area Code" in the Source
Columns list.
- Double-click (space).
- Double-click "Local Number".
- 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.
- Click OK.
The new
column is created.