Skip to Main Content
Spotfire Ideas Portal
Status Implemented
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Jul 10, 2016

Use "Category" and "Value" for new data columns when using One-Click Unpivot

When using One-Click Unpivot, the newly created data column names are a concatenation of the fields that have been transformed.  While helpful to see exactly what columns have been transformed, the names become very long when a large number of columns are transformed.  These columns names most often need to be renamed to fit the context of the current data table.  My request is to use the values "Category" and "Value" for the newly created fields as is the default when performing the unpivot operation manually.

Implemented in 7.11
  • ADMIN RESPONSE
    Dec 13, 2017

    Starting with Spotfire 7.11 this is now the case. The resulting columns are named Category and Value instead of a comma separated list of origin column names and "Value for" and a comma separated list.

  • Attach files