Alteryx Designer Desktop Discussions

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

Filter Formula to Exclude Fields

mustufa2019
8 - Asteroid

I am trying to use the filter formula to exclude accounts starting with "Model..." within the Operator Name; see screenshot 1 below:

 

I tried using the below formula (see screenshot 2) but it didn't work. Any help would be appreciated. 

 

 

mustufa2019_1-1578372906521.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

mustufa2019_3-1578373142139.png

 

 

 

 

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

Just use "MODEL", you don't need the .*

or 

 

left([operator name ],5) = "MODEL"

 

 cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
mustufa2019
8 - Asteroid

@MarqueeCrew this worked, thank you!

Labels