Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to Convert V_WString to Float without truncation

nimit_b19
7 - Meteor

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 :

 

a0.png

 

 

 

 

a1.png

 

 

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

 

 

2 REPLIES 2
danilang
19 - Altair
19 - Altair

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

That works perfectly! Thank you @danilang.

Labels