Designer error: numeric field over flow

Question

Hello community,

I recently created a workflow which pulls data from a SQL table, runs through already-fixed macros, and the final results are inserted in the end SQL table. The end results include Varchar, Int and Decimal.

Every tool runs fine, but the final output tool shows the following error:

Numeric Field Overflow

Detail: the absolute value is greater than or equal to 10^2 for field with precision 12 and scale 11

I have tried to put a select tool to change the size of the columns, but nothing worked.

Do you have any ideas as to what might be wrong?

Thanks!

Error.JPG

aveloudi · Accepted Answer

Thanks for your answer.

I tried your method but got a different error this time.

I resolved the problem by changing the data type from decimal into float in both Alteryx and SQL.

Regards