We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Microsoft Access Database Engine: Invalid precision for decimal type

AlterMini
6 - Meteoroid

I am getting error in my Output Data. Fixed decimal 47.2 is the format in all numeric fields. How to fix the error

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @AlterMini 

 

Can you reduce the precision to 15.2 or 10.2 is precision up 47 digits really needed ?

AlterMini
6 - Meteoroid

Thanks for your suggestion. Meantime I changed format into Double, it works.

atcodedog05
22 - Nova
22 - Nova

Hi @AlterMini 

 

Its actually doing the same thing but your decimal precision may not be 2 digits.

AlterMini
6 - Meteoroid

Thanks atcodedog4. your suggestions also works. 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @AlterMini 

Cheers and have a nice weekend!

Labels
Top Solution Authors