Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Mar 6, 2020

Custom expression when performing unpivot/pivot data transformation

It would be useful to have the possibility to use custom expressions in pivot transformations. This would allow users to already create tailormade columns during the transformation phase, rather than once the data is loaded completely.

  • Attach files

Add selecting columns by-expression option to the pivot select-column window

Pls, refer to the attached .pptx. Our users require to have the same functionality with the TIBCO pivot transformation. The user needs to reselect parameters of the pivot(via refresh table with prompt) when running a template for different prod...
over 5 years ago in Spotfire / Data Management 0 Future Consideration

Dynamic Unpivot

Have checkbox in Unpivot Transformation UI to automatically "transform" new columns from source. This is useful for common 'wide' data sets where new time-series data comes as new columns in source. Whenever the source updates, currently one must ...
almost 4 years ago in Spotfire / Data Management 0 Future Consideration