Conversion Error for number

Question

Hi community,

I would like to ask how do we solve the conversion error issue for the following number :

Original input ( Datatype format - Vstring)

After converting ( Datatype format - double)

i use the select tool to change the datatype from Vstring to double.Would like to ask how do we normally convert data if there is long decimal number and avoid the conversion error issue.

THank you.

binu_acs · Answer

@SH_94 This is not a conversion error, it is the information, when you convert a large number into double data type alteryx round the number to the nearest 6 decimal places.

ShankerV · Answer

Hi @SH_94

To explain you why I have used the FixedDecimal as 18.14 is

I see the data's in your screenshot. Its all 18 characters long including the .(full stop)

380.26637996835586

Hence I have used the full length as 18 and the precision as 14

Hope it helps!!!!

Many thanks

Shanker V

ShankerV · Answer

Hi @SH_94

There are two ways to change the datatype to fixed decimal.

1. Via Select tool

2. Multi Field Formula tool

Many thanks

Shanker V

Conversion Error for number.yxmd