Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Jan 16, 2018

Multiple Unpivot Transformations in One Pass

Sometimes, there might be a data table where certain columns come in pairings.  For instance, if I have a scaled score in 3 subjects for a student, and then I have a percentile rank for the same 3 subjects for a student, the data is likely to come in a wide data table, with multiple columns and one row per student.  It would be useful to have the data transformed so that I have a category / value pairing for scaled score, and another for percentile rank.  At the moment, I have to create a separate data table, do one unpivot transformation for the scaled score and then merge the result of another unpivot transformation.  It would be great to be be able to create sets of category / value unpivot in one pass.  That way, you lose the risk of not being able to match the data properly in the merge.

  • Attach files