Skip to main content

How does Spotfire name the columns in an information link?

Rich Talbot
  • Created
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

Comments

0 comments

Article is closed for comments.