Alteryx Designer Desktop Discussions

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

Filter tool question

DPRC
8 - Asteroid

Hello All,

 

I have a question regarding the filter tool and the "does not contain" expression. I was hoping to have 1 expression with 4/5 different phrases to remove from the data but had to apply the filter tool 4 times instead (See beneath)

 

I don't come from a programming background so the expression writing and the nuances associated with that, I haven't mastered yet.

 

How should I have approached this to?

 

Thanks

DPRC_1-1591818814854.png

 

3 REPLIES 3
ChrisTX
16 - Nebula
16 - Nebula

Use AND in a single formula:

 

!CONTAINS([Status Upon Delivery], "error") AND !CONTAINS([Email], "sales") AND ....

 

Chris

jeff_reynolds
10 - Fireball

@ChrisTX is correct.

 

Try the attached workflow to see that logic in action.

 

Edit: updated workflow with another example. 

DPRC
8 - Asteroid

Thanks both, this is great.

 

I will work on the expression writing.

Labels
Top Solution Authors