Pivot stage input link columns

The following example illustrates data input to the Pivot stage.

The Columns tab of the Inputs page contains three input columns with sales data: JAN_Sales, FEB_Sales, and MARCH_Sales. The columns are as follows:

Table 1. Input columns
Column name	SQL type	Length	Scale
CUSTID	Integer	10
LNAME	VarChar	10
JAN_Sales	Decimal	10	2
FEB_Sales	Decimal	10	2
MARCH_Sales	Decimal	10	2

Note: For any column, the data type documented in SQL Type must be the same as the data type in the source table.

The data for the source rows for the input columns looks like this:

Table 2. Input Source Rows
CUSTID	LNAME	JAN_Sales	FEB_Sales	MARCH_Sales
100	Smith	$1,234.00	$1,456.00	$1,578.00
101	Yamada	$1,245.00	$1,765.00	$1,934.00