Learn more about the Alteryx Maveryx Universe recently announced at Inspire 2023!

Alteryx Designer Desktop Discussions

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

Filter tool formula

Ekta
8 - Asteroid

Dear all, 

 

Please help me with below query-

 

In my dataset i have a column where the data should always be like A123B, means first and fourth letter are alphabets and middle 3 are numbers, Sometime due to readability issue , 3 in A123B is read as A12BB or 8 can be read as B etc,  i would like to filter it out when this happens.

 

Please help me with the filter formula for this.

My current filter formula !IsEmpty([A]) and !IsEmpty([B]) and !IsEmpty([C]) and !IsEmpty([D])

i would like to add one more condition on column E ie if E is (first and fourth letter are alphabets and middle 3 are numbers ) then its good to go else no.

 

ABCDE
John12Apple34A12BB

 

Thank you in advance:)

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @Ekta 

 

The extended filter formula would be

 

!IsEmpty([A]) and !IsEmpty([B]) and !IsEmpty([C]) and !IsEmpty([D]) and REGEX_Match([E], "\u\d{3}\u")

 

Workflow:

atcodedog05_0-1629791107975.png

 

Hope this helps : )

Ekta
8 - Asteroid

@atcodedog05 Thank you so much , works perfectly fine:)

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Ekta 

Cheers and have a nice day!

Labels