CODEWITHSUNDEEP
spotfire
blakeoft
blakeoft

Reputation: 2400

Changing data type does not fix loading error

When this dxp was originally created, the data type for one column was automatically chosen to be integer. At the time, I was ok with this as it was a reasonable type. However, it is now possible for non-integer values to appear in this column. It appears as though any non-integer value is removed from the analysis, which I suppose makes sense. When I add a transformation to change the data type of this column from integer to real, and reload the analysis, the load error persists, and the data is still missing. Is there anything that I can do to this data to be recognized?

Here is the notification that is returned:

Linked data table 'data': 
The column 'col1' contained at least one incorrect value: '1.5'

Upvotes: 0

Views: 765

Answers (1)

Tyger Guzman
Tyger Guzman

Reputation: 758

Replace the data source with the same data source but when previewing the data change the type to string.

Upvotes: 1

Related Questions