Identifying Incoming Columns :: SAS(R) Data Surveyor for Clickstream Data 2.1: User's Guide, Second Edition

Problem

You want to identify the meaning of the incoming columns to the Clickstream Parse transformation. To do this, maintain the column mappings between the source tables from the Clickstream Log transformation (or any other previous transformation) and the Clickstream Standard Input Columns Table. If the column name in the source table matches a Clickstream Log Standard Column, then the mapping is performed automatically. For information about the Clickstream Standard Input Columns (Clickstream Parse Input Columns), see Clickstream Parse Input Columns.

User columns defined in the Clickstream Log transformation should be mapped on the Input Mappings tab in the Clickstream Parse transformation when they are intended to serve in the role of a Clickstream Parse Standard Input Column. Otherwise, their values can be used in a rule or simply passed through to the Clickstream Parse transformation target table using the Target Table tab.

Note: You can also define user columns on the User Columns tab on the Clickstream Parse transformation and tie them to parameters on the Clickstream Parameters tab (also on the Clickstream Parse transformation). Additionally, you can create user columns based on the rules that you create on the Rules column on the Clickstream Parse transformation. The user columns created on these tabs are added to the output on the Target Table tab on the Clickstream Parse transformation. These user columns do not appear on the Input Mapping tab.

Solution

You can maintain column mappings on the Input Mapping tab in the properties window for the Clickstream Parse transformation. The source column data comes from the Clickstream Log transformation (or the output table of any previous transformation or another input table) that precedes the Clickstream Parse transformation in the process flow.

The Column assignments for list box on the Input Mapping tab contains Clickstream Parse Standard Input Columns. If you add a column on the User Columns tab of the Clickstream Log transformation or the Clickstream Parse transformation, you can map it here.

Perform the following tasks:

Tasks

Maintain Column Mappings

The Input Mapping tab contains a set of tools to map between the output columns of the prior transformation and the input columns of the Clickstream Parse transformation.

Perform one of the following tasks to map between the input and output columns:

Click Map all columns to map between all of the input and output columns. Columns are automatically matched when the column name of a source table matches a column name in the output table.
Click Map selected columns to map between a set of columns that you have selected and the appropriate output columns.

Other Tasks for Input Mapping

For information about other ways to manage input mapping, such as building an expression for a derived mapping or deleting a mapping, see the Help for the Input Mapping tab.