Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error: Numeric fields can only contain numbers: 'value'

Alteryx_KB
Alteryx
Alteryx
Created

Issue

 

Error: Numeric fields can only contain numbers: '@1'

 
 

Environment Details

 
  • Alteryx Designer
    • All Versions
  • Filter
  • Filter In-DB


Cause

 

There is a disconnect between the operation and the data type. In the image below, the Filter tool is trying to filter the records that are greater than or equal to a number, but the value is a string.


 

 

Resolution

Make sure that both the Filter operation and the field’s data type are numeric.
 



image.png

Additional Resources

No ratings