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

Hi All,

I have an amount column in a csv file with the following data:

ColumnA

45.6

50.4567

445678.67

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

Output

Accepted answers

Banu

Hi All,

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

Thanks,

Banu

All comments

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703