Skip to Main Content
Spotfire Ideas Portal

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

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Jan 15, 2021

      I do not think this has been implemented yet, has it? Please add this update to Spotfire ASAP! It would be extremely useful.

    • Guest
      Reply
      |
      May 15, 2019

      I think 10 votes is way to little for TIBCO to consider this idea seriously.

       

      The workaround is to create a data table by yourself in TextArea with an html code dynamically changed by IronPython script. Found it here: http://tainguyen.me/blog/spotfire-populate-data-table-into-text-area-with-html-format/

    • Guest
      Reply
      |
      Apr 29, 2019

      Hi Dmitro, nice to see you here. I have moved to Spotfire too, and fully agree with your suggestion.

    • Guest
      Reply
      |
      Nov 29, 2018

      Could this please be prioritized in the coming releases. It is really frustrating not being able to add labels to column names per visualization.

    2 MERGED

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

    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
    over 5 years ago in Spotfire / Visualization 0 Future Consideration
    5 MERGED

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

    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