Character,decimal&binary character cannot have a precision of 0 error

[Banu]

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

[JohnJPS]

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?

[Banu]

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

[Banu · Accepted solution]

Hi All,

changed the database column datatype as double precision and it started working!!.

Thanks,

Banu