Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Exception in Filter

jboschee
8 - Asteroid

Hi everyone,

 

I'm trying to make an exception in my filter.

 

Team Name    DOES NOT CONTAIN    Chicago

 

but I want to keep in Chicago Bears

 

Not sure if this is possible or if I'm using the wrong approach.

 

Thanks for the help in advance!

2 REPLIES 2
David-Carnes
12 - Quasar

OK, Text tool  has

   da bears    *   
1 Chicago
2 Chicagoland
3 Chicago Tribune
4 Chicago Bears
5 Taste of Chicago
6 Jacksonville Jaguars

 

Filter has  a Custom Filter:

[da bears] = "Chicago Bears"
or !Contains([da bears], 'Chicago')

 

jboschee.PNG

 

Output = 

da bears
Chicago Bears
Jacksonville Jaguars

 

If you need something to pull out of sentences we'll need to look at regular expressions.

 

Best,

David

 

jboschee
8 - Asteroid

Awesome!  Thanks David

Labels