Hi,
I am using Alteryx workflow to populate data in Teradata table. There is a column named 'Target' consisting of target values for each metric and have fixed the field type as FIXED DECIMAL (21.4). The output shows correctly in the browse tool as well as in the output anchor, however in Teradata table the values get multiplied by 1000. It would be a great help if someone knows a work around this. Please refer the dummy data below.
Correct values (shows correctly in browse tool too):
| id | Target |
| 1 | 451,367,895.67 |
| 2 | 598,384,050.03 |
| 3 | 658,978,256.81 |
| 4 | 725,690,873.92 |
| 5 | 860,365,388.60 |
| 6 | 980,564,114.91 |
| 7 | 997,831,966.69 |
Values showing in teradata table:
| id | Target |
| 1 | 4,513,678,956,700.00 |
| 2 | 5,983,840,500,300.00 |
| 3 | 6,589,782,568,100.00 |
| 4 | 7,256,908,739,200.00 |
| 5 | 8,603,653,886,000.00 |
| 6 | 9,805,641,149,100.00 |
| 7 | 9,978,319,666,900.00 |
