ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Select tool error

smallpotato
7 - Meteor

Hi, i am doing data cleansing for a set of data. I used the select tool to change datatype and length of data. All of them are in one of these three data type (i.e. WString/ Date/ Fixed Decimal). However, I got an error shown "Invalid field scale:'2'; must be between 0 and 1. As my understanding, all of these three datatypes not having 1 as their maximum size. So would like to ask what may probably goes wrong?

1 REPLY 1
PhilipMannering
16 - Nebula
16 - Nebula

Can you share a workflow with sample data that replicates this error?

Labels
Top Solution Authors