Managing Output Table Columns

Overview

Sometimes you want to select the columns that are present in the output from the Clickstream Parse transformation. In this case, you can use the Target Table tab in the properties window for the Clickstream Parse transformation.

You can select additional output columns from the following sources:

The Clickstream Log Table lists all input columns in the source table for the Clickstream Parse transformation. To simply pass through an input column to the output, select the column from this list in the Available columns list box. Then move it to the Selected columns list box.
The Clickstream Parse Standard Columns lists all possible Clickstream Standard Output Columns. This source includes new output columns that are generated by the Clickstream Parse transformation.
The Clickstream Parse User Columns Table lists all user columns that are defined on the User Columns tab.

Note: You must add any user columns that you want to include in the target table to the Selected columns list box on the Target Table tab. The user columns that you define are not automatically included in the target table.

Specify the Output Columns from the Clickstream Parse Transformation

Perform the following steps to specify the output columns from the Clickstream Parse transformation:

Select the columns that you want to add to the output table from the columns listed in the Available columns list box.
Click the arrow between the list boxes to move the columns to the Selected columns list box. Note that you can also select columns in the Selected columns list box and return them to the Available columns list box.