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

[Alteryx_KB]

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.
 

Additional Resources

• https://help.alteryx.com/current/designer/data-types 

• https://community.alteryx.com/t5/Interactive-Lessons/Understanding-Data-Types/ta-p/73958