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.