Spotfire Analyst: My dashboard's data table with column type 'integer' is now getting 'real' values, which conflict.

Details:

My dashboard was originally populated with a Data Table whose column was designated as type Integer, which was originally appropriate, since it matched my raw data. 

Problem:

Later, some of the raw data that populates this integer type column now includes real / float values. When these values come into my dashboard, the decimal portion of the value may get truncated so that it conforms with the integer data type. Alternatively, certain data imports may throw a warning, or may not import at all.

The Spotfire 'transformation' feature allows for changing a data type after it gets imported. However, this may not be a solution, since the decimal places get truncated as they import, before the transformation occurs.

Solution:

Open the Data Canvas of your dashboard (the bottom fly-out icon in left margin), select the Data Table that has the column, and then click the Replace icon toward the top right corner of the canvas. Select the source containing your raw data, and when re-mapping make sure that your column gets declared as Real rather than Integer.

The below Knowledge Base article describes more detail about replacing a data table in Spotfire.

https://support.revvitysignals.com/hc/en-us/articles/4408240841876-Changes-in-Spotfire-version-10-How-to-Replace-Data-Table-in-Spotfire-version-10