I am trying to output Alteryx results to a new tab in SQL using the output icon. The table does not exist in SQL and i am using Alteryx to automatically create the table when outputting the results. My challenge is the numeric fields.
If I set up the numeric field to “Double” in Alteryx, the value will show as scientific notation in SQL. If i set up the numeric field as “Fixed Decimal (25,2), then the value show incorrectly as below.
| Alteryx | SQL | Comment |
| 7896061.00 | 78960.61 | incorrect |
| 7659000.00 | 7659000 | correct |
| 7625952.39 | 7625952.39 | Correct |
| 4857125419.00 | 48571254.19 | Incorrect |
Anyone runs into the same issue? Thanks for the help!
