How to find the "is not a valid number"

[learnalteryx]

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 solution]

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-ce... 

[Felipe_Ribeir0]

Hi @learnalteryx 

Here is one way that works particularly well if your input is a text field.

REGEX_Match([Value], '(\-)?(\d+)(\.\d+)?')