Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Data Management
Created by Guest
Created on Mar 16, 2018

SingleReal and Real Data Types Match in joins

Spotfire sometimes assign a Real data type as SingleReal and other times as Real, even if the data type is defined as Real in the source SQL data table.  This is seems weird, and is inconvenient for joining data tables, since the data types must match.  

 

I suggest making Spotfire see both SingleReal and Real as the same thing for the purposes of matching.  It's a pain to change all those data types in the column elements or have to add a change data type transformation with every join.

  • Attach files
  • Guest
    Reply
    |
    Mar 20, 2018

    An offshoot of this idea is to automatically allow the join of any numeric data types.  I can't imagine a downside of automatically converting an integer data type to a real for the purposes of allowing a join to work.