How to make Spotfire detect column name as name row when encountering numeric values in data set header row?
Article ID: KB0078103
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All Versions. |
Description
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.
| Name | Role | 5 |
|---|---|---|
| Jim | Manager | 1.4 |
| Jack | Engineer | 2.5 |
Issue/Introduction
How to make Spotfire detect column name as name row when encountering numeric values in data set header row?
Resolution
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.
Feedback
Yes
No
Powered by
