Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Visualization
Created by Guest
Created on Oct 23, 2017

Edit table column names without changing the column properties

Almost all visualizations allow expressions and display names for column names. Even though Table visualization allows user to select columns it does not allow him/her to enter separate display name for every column. Instead, Spotfire manual suggests renaming columns through column properties. Given that nearly all other visualizations allow user to specify a Display name, there's rarely a need to change column properties for any reason other than table visualization. 

There are a couple of reasons why changing column name in column properties is a bad idea:

1) allows only one name per column in an analysis type. User might want to call a column in a table slightly differently, depending on the page context

2) once renamed, new "human-readable" name is used everywhere in expressions, transformations, etc. This is really difficult to troubleshoot, as sometimes names get long and use special symbols. As a result, formulas become bulky and difficult to edit

3) when data table is replaced (using Replace Data Table functionality) column renaming can be gone together with old table, so the newly brought datatable might have the same external names, but because renaming information is gone, all expressions will resolve to error.

 

Ref: https://community.tibco.com/questions/tibco-spotfire-75-how-change-header-table-visualization-without-change-name-property-field

2 MERGED

Allow the specification of "Display Name" on a Table visualisation

Merged
In many other places you can override the field name using the AS "My Col Name" or Display Name field ... this should be included with Table visualisations too
about 5 years ago in Spotfire / Visualization 0 Future Consideration
5 MERGED

Rename Column Names in Visualisations (mainly Table, CrossTab etc)

Merged
Should be able to rename Column Names right in the Visualization preview, instead of column properties. Some visualizations allow custom expression for this, but not Tabular and CrossTab.
over 8 years ago in Spotfire / Visualization 1 Future Consideration