Skip to main content

How to make Spotfire detect column name as name row when encountering numeric values in data set header row?

Rich Talbot
Date Posted: 2019-05-30
Product: TIBCO Spotfire®

Problem:

How to make Spotfire detect column name as name row when encountering numeric values in data set header row?


Solution:

Consider the below data set and observe that it is having numeric value as a column name "5".
 

NameRole5
JimManager1.4
JackEngineer2.5
When importing the above dataset from Excel into Spotfire, the header row containing the names of the columns is initially regarded as a data row by the excel import wizard. For Spotfire to identify the data set header row and automatically make it as "Name row" instead of "Data row", use a single quotation mark (') before the column name (5) in excel and try importing the dataset. This will cause Spotfire to treat it as a string and the column detection will work.

User-added image

Comments

0 comments

Article is closed for comments.