Jump to content

Spotfire string to real conversion, wrong decimal change comma to dot

Xav Dou

Recommended Posts



I have an issue to convert STRING to REAL.

I have a datatable with all the columns in STRING format and some of these columns have "numbers" (for example, 12345 or 12345.99). At that time, the decimal separator is a dot (.)

BUT when i import the data into Spotfire, it automatically changes to dot to comma... and the datatype is still STRING.

The issue comes when i want to convert these columns to REAL. I go inthe canva of the Spotfire report and i chose the transformation "change data type".

The numbers without comma are correctly converted BUT the numbers with comma disappear. It returns blank value. (see screenshot).

Any idea how to solve that please

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...