How to find the "is not a valid number"

Question

Hi
I have a very basic question. Whenever I use the select tool, an error message pops up stating, "Field: is not a valid number." Could you help me understand what this means?  The field in question is essentially numeric. I am trying to identify which cells might be causing this error. Could you kindly recommend a tool or method that could help me pinpoint the problematic cells?

Thank you in advance for your guidance.

caltang · Accepted Answer

You can use a Filter Tool with:

IsNumber()

Please refer here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-check-if-values-in-a-cell-are-numeric-or-contains-only/td-p/738667