Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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