Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Decimal truncated in input step

JM
6 - Meteoroid

I am using the Simba Salesforce ODBC driver to pull in data from table within Salesforce.  One of fields is a numeric field with decimals.  When the data is loaded, it looks like some of the decimals are being truncated and are not available in the import, but when this is compared to the source I can see the numbers.

 

How can I input the full table from the source without data being truncated?

 

For example:

The source has a value of 

1633.8461538461538

 

Once loaded into Alteryx, the number appears as 

1633.84615384615

 

The 38 from the source is not appearing and cannot be seen in the browse tool either.  The field shows a Type of Double.

 

I have tried to change the data type using select after the input, but this does not change the result.  

1 REPLY 1
Luke_C
17 - Castor
17 - Castor

Hi @JM 

 

As I understand it, a double can only hold 15 digits, which lines up with what you're seeing:

https://help.alteryx.com/20231/designer/data-types#:~:text=A%20standard%20double%2Dprecision%20float....

 

 

Labels
Top Solution Authors