Number conversion and error

unknown

Hi Community,

I am facing an issue as column value is changing after data type conversion from v_wstring to double.

Value:

8.93274807963631e-02, i want to keep this value as it is '0.089....'

Conveted value:

8.932748 with error The display value was rounded to 6 decimal places for clarity.

Can anyone help ?

Thanks in Advance !

Help

Accepted answers

binu_acs

@Inactive User Can you try to change the w_string type length like below and use the toNumber function to convert to double as @Luke_C mentioned?

All comments

binu_acs

@Inactive User can you change the size of the v_string and try again to get the value 0.089… The message you are seeing is not actually an error message

unknown

Hi @binu_acs , Thanks for the reply, but data type is V_WString.

Luke_C

Hi @Inactive User

Check out this article:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Converting-Values-from-Scientific-E-Notation/ta-p/21885

With your data - see below and attached. The message you see about rounding to 6 decimals is just for presentation purposes in the results window. No data is lost.

New Workflow1.yxmd

binu_acs

@Inactive User Can you try to change the w_string type length like below and use the toNumber function to convert to double as @Luke_C mentioned?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703