Hi All,
I have an amount column in a csv file with the following data:
ColumnA
43
45.6
50.4567
445678.67
60
When I try to load this columnA to a database column with datatype decimal (40,6) alteryx throws an error saying that 'Character,decimal & binary parameters cannot have a precision of zero '
Thanks,
Banu
Solved! Go to Solution.
Hi Banu,
Just a thought sent via mobile phone here: have you tried using a Select tool, to force the given column to something like Fixed Decimal 11.6, to see if that helps?
Hi John,
I have tried using Fixed Decimal datatype something like 20.6 but still it gives the same error.
It is because numbers in the columnA has mix of Integers and decimals. Not sure how to handle it.
Thanks,
Banu
Hi All,
changed the database column datatype as double precision and it started working!!.
Thanks,
Banu