filter tool

[AbdulBasit]

how to seperate string data and numeric data in filter tool.Can any one tell me the formula.

It will be appreciated.

[atcodedog05]

Hi @AbdulBasit 

You can use this expression in filter

REGEX_Match([Value], "\d*")

This expression check whether its a number.

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[AbdulBasit]

dude you awesome thanku you very much.

Tell me one thing does alteryx has its own language or some other like "R" or Python.

[atcodedog05]

Hi @AbdulBasit 

Alteryx is not code intensive 

But it does have good set of formulas to help manipulate data.

https://help.alteryx.com/current/designer/functions

The one i am using is a regex function which says match the regex. And regex is common in all languages and \d* is numeric data.

Hope this helps 🙂

[atcodedog05]

@AbdulBasit 

PS please post the questions in Discussions channels or the main home page. So that people can help you and you will able to mark solution 🙂