Altair® Panopticon

 

Pivoting and Unpivoting  Data

Data comes in two major formats: long, where the columns can’t be reduced and has many rows vs wide, where the columns can’t be reduced and fewer rows are needed.

 

Data can be transformed from long to wide or back again. However, the term pivot and unpivot are sometimes used for either transformation. In Panopticon Designer (Desktop), we define pivot as a movement from long data to wide data and unpivot as a movement from wide data to long data.

The use of either pivoting or unpivoting data is based on the ease of calculation or to more easily join the data together.

NOTE: Panopticon Designer (Desktop)’s pivoting has special requirements due to the real time aspect of the product.