Custom filter for multiple categories

[skeen503979]

Hi there, 

I know this is a pretty basic question but it has me stumped today.  I'm trying to create a custom filter that will exclude several equipment types from my data.  Currently, it is excluding everything and 100% of my data comes out of the FALSE tab.

How can I rewrite this so that only those categories listed are excluded from the data?

Thx!

[AngelosPachis · Accepted solution]

Hi @skeen503979 ,

The syntax of the conditional statement in the filter tool is slightly different for Alteryx to recognise what you mean. Try:

[Equipment]!="Antenna" AND [Equipment]!="Case" AND [Equipment]!="Combo Pack" AND [Equipment]!="Data Interface" ......

Even if it's a very long statement, you can try adding what you expect your equipment column to be equal to.

Cheers,

Angelos 

[skeen503979]

Thanks @AngelosPachis that worked great!

[jferrone]

I believe you should be able to do [Equipment] NOT IN ("Antenna", "Case", "Combo Pack", etc...)

[David-teryx]

Thanks @jferrone that worked for me.