Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Data Access
Created by Guest
Created on May 31, 2018

RELATED IDEAS

Data Type of Column that starts as Int but later contains strings doesn't read the strings

Hi,

In the situation where a column in an excel file contains strings and integers but starts with integers, the data type of the column read into Spotfire is integer.  It can't be changed from within Spotfire to read string and read in the string data.  It must be changed from within the data source itself.  Please see attached video. 

The idea is that Spotfire recognize this data type as a string, or at least except the manual change to string and not leave the strings as null.

Thanks,

Olga

Data Type Int -...
Data Type Int - String.mp4
 Data Type Int - String.mp4
Open full size
Data Type Int - String.mp4
  • Attach files
This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us