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, 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 join the data together more easily.
NOTE: Panopticon’s pivoting has special requirements due to the real-time aspect of the product.
(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.