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 |
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.