Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

How does Spotfire name the columns in an information link?

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

How does Spotfire name the columns in an information link?


Solution:

How does Spotfire name the columns in an information link?
A Spotfire information link's columns are named using the names of the Spotfire Information Services column elements that were used in creating that information link. When a column element is created from a column in a data source, it is named using the column name from the data source. But the user can manually rename a column element, using the Information Designer.

The following characters are forbidden in column element names:  / \ * " ? : < > |

If the user has renamed the column element, then the information link's auto-generated SQL query will have an AS clause that uses both the data source's name for the column and the name of the column element, such as the following.

     SELECT
        DataSourceColumnName AS NameOfTheColumnElement

Related articles