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.
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.