Example of vertically pivoting data (DataStage®)

In this example, the Pivot Enterprise stage is set up to vertically pivot some data and aggregate a monthly average of sales.

The following tables provide examples of data before and after a vertical pivot operation.
Table 1. Input data for vertical pivot operation
REPID last_name Q_sales
100 Smith 1234.08
100 Smith 1456.80
100 Smith 1578.00
101 Yamada 1245.20
101 Yamada 1765.00
101 Yamada 1934.22
Table 2. Out put data for vertical pivot operation
REPID last_name Q_sales (January) Q_sales1 (February) Q_sales2 (March) Q_sales_average
100 Smith 1234.08 1456.80 1578.00 1412.96
101 Yamada 1245.20 1765.00 1934.22 1648.14

The following screen capture shows the settings for a vertical pivot set by clicking Edit on the Pivot Properties section of the Stage tab.

Figure 1. Example of vertical pivot settings on the Vertical pivot pageShows the settings for a Vertical pivot page configured to generate multiple columns containing the vertically pivoted data, and columns containing an aggregated sum and first value.