Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

how to use filter accounts ID contains numbers.

Beckyli
アステロイド

how to use filter only slow accounts ID contains numbers.

 

Beckyli_0-1666042879933.png

 

3件の返信3
Felipe_Ribeir0
ネビュラ

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
クエーサー

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

 

スポイラ
acarter881_0-1666043449799.png

 

 

Beckyli
アステロイド

but some of accounts contains 4 number 

ラベル
トップのソリューション投稿者