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".
| Name | Role | 5 |
|---|
| Jim | Manager | 1.4 |
| Jack | Engineer | 2.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.
Comments
0 comments
Article is closed for comments.