The Pivot Recipe

Although the Prepare recipe includes a pivot processor, the Pivot recipe allows you to transform rows into columns with greater control and more customized aggregations. The Pivot recipe can also execute the pivot natively on external systems, such as SQL databases or Hive.

The Foundational materials, including the Excel to DSS track, have already introduced the mechanics of the Pivot recipe.

The following tutorials go into greater detail — whether you only need to pivot values or pivot and perform an aggregation, as in a pivot table.