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

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
Top Solution Authors