Number conversion and error

[Inactive User]

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 !

[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

[Inactive User]

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.

[binu_acs · Accepted solution]

@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?