How to Convert V_WString to Float without truncation

[nimit_b19]

I am pulling in data from an API. The data comes in in JSON Format. All of it is converted to V_WString while parsing.

There is a field called 'Elapsed percentage' which is supposed to be a Float field. When I use the Select tool to convert this field to Float, I am getting erroneous data in some rows. I'm guessing Alteryx is truncating large values.

Example :

7074.81 got converted to 7 and 3351.95 to 3. Why is this happening and how can I fix this?

[danilang · Accepted solution]

Hi @nimit_b19 

Your data has has embedded commas "," in the string.  Use Replace([ElapsedPercentage],",","") to remove them before trying to convert to a double

Dan 

[nimit_b19]

That works perfectly! Thank you @danilang.