Alteryx Designer

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

Conversion errors : Fixed Decimal and Precision

Highlighted
6 - Meteoroid

Hello,

 

In my input data (xlsx file), I have financial numeric fields so precision is paramount.

So I decided to change to type from V_String to Fixed Decimal. 

 

I'm having 2 types of conversion errors : 

 

Error 1: "3.3320348528E8" is not a valid FixedDecimal. FixedDecimal values must be of the form: -nnn.nn

 

Error 2: "0.07650814271753212" has too many digits after the decimal and was truncated.

 

 

The first error, I think it's an excel error. But I dont know how to get around it. 

The second error is probably a parameter error on my part. In the select tool, I put Fixed Decimal (255.15)

 

Thank you in advance.

Highlighted
16 - Nebula

Try changing from V_String to Double first and then to Fixed Decimal

 

DavidP_0-1586431186617.png

 

Highlighted
Alteryx Partner

Hey @AmineB 

 

Hopefully this helps you. I took an excel file. Created 4 different field types and brought them into Alteryx. This is what you get when you swap to fixed decimal of different precisions. If you go over the actual precision it will end in Null value. 

 

joshuaburkhow_0-1586432129010.png

 

 

I noticed on your second one you picked 255.15 as your parameters. Try just doing something like 20.15

 

Labels