This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've created an Alteryx workflow to extract and consolidate data from a SQL Server database (via in-db), and then write the output to a different database using the "output data" tool.
However, I get an error message at the last step (output data): "Specified column precision 39 is greater than the maximum precision of 38". However, I don't remember setting any column precision so i'm not too sure why I'm getting this error message.
I'm using the Formula In-DB tool, is it possible to change the value of 'Scale' here as I can't seem to see it. The column type is already FixedDecimal (with 40,2 size) so I tried to convert/cast this column and specify the length of the decimal but it doesn't seem to work. Am I doing it the right way?
So using the formula in-db tool, I've created a new output field and have used convert and cast to change the precision of the decimal. I've tried both double and fixedDecimal types for the output field as well.
cast("SumColumn1" as decimal(2,4)
But when I check the metadata, the new field is still coming out as fixedDecimal with size 40,4. Did I write the formula incorrectly? Alteryx seems to have increased the precision when I summarize Column1 because the size before the sum is 20,4.