In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

filter tool

AbdulBasit
8 - Asteroid

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

It will be appreciated.

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @AbdulBasit 

 

You can use this expression in filter

 

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

This expression check whether its a number.

 

Workflow:

atcodedog05_0-1606823354144.png


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
8 - Asteroid

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
22 - Nova
22 - Nova

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
22 - Nova
22 - Nova

@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 🙂

Labels
Top Solution Authors