Date Posted: 2019-05-30
Product: TIBCO Spotfire®
How to make Spotfire detect column name as name row when encountering numeric values in data set header row?
Consider the below data set and observe that it is having numeric value as a column name "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.