Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

how to use filter accounts ID contains numbers.

Beckyli
8 - Asteroid

how to use filter only slow accounts ID contains numbers.

 

Beckyli_0-1666042879933.png

 

3 REPLIES 3
Felipe_Ribeir0
16 - Nebula

Hi @Beckyli 

 

Using this regex expression you gonna filter every row for Account that has any character + five numbers at the end (like ANYTHING_11111). I dont know all your dataset, but for the sample provided it will work.

 

 

Felipe_Ribeir0_0-1666043339876.png

 

acarter881
12 - Quasar

@Beckyli Here's an example using the REGEX_Match function.

 

Spoiler
acarter881_0-1666043449799.png

 

 

Beckyli
8 - Asteroid

but some of accounts contains 4 number 

Labels
Top Solution Authors