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.
Hi @JM
As I understand it, a double can only hold 15 digits, which lines up with what you're seeing:
User | Count |
---|---|
108 | |
89 | |
78 | |
54 | |
40 |