Add custom filter for multiple fields

[sbb]

i would like to create a custom filter so that I can filter by two unique fields in the table, employer name and subscriber. What is the expresssion to add the additional filter? This is what I have so far:

Contains([GRP_EMP_NAME1],"acme co")

Thank you.

[MarqueeCrew · Accepted solution]

Contains([GRP_EMP_NAME1],"acme co")

OR

Contains([Subscriber],"Alteryx")

how about that?

[Benedetta13]

Hi!

You can definitely add a custom filter inside the filter tool saying: 

Contains([GR P_EMP_NAME1],"acme co") AND Contains([SUBSCRIBER_COLUMN],"subscriber")

In this way you can filter your dataset for the employer name and subscriber that you want!

Thanks 

Benedetta

[sbb]

Thank you for the solution. It worked.

[MRioux]

Can you help me trouble shoot this formula: I want to include "H" from field [D/C] AND exclude "ZQ", "ZR", "ZS", "ZP", "ZV" from the [Type] field.  This is what I wrote so far but it's not excluding the [Type] criteria:

[D/C] = "H" AND
([Type] != "ZQ" OR
[Type] != "ZR" OR
[Type] != "ZS" OR
[Type] != "ZP" OR
[Type] != "ZV")

Thank you,

MRioux

[Benedetta13]

Hi MRioux,

Try with:

[D/C] = "H" AND
([Type] != "ZQ" AND
[Type] != "ZR" AND
[Type] != "ZS" AND
[Type] != "ZP" AND
[Type] != "ZV")

If you use OR it will not exclude all of them at the same time I am afraid!

Cheers

B

[MRioux]

That worked! Thank you so much for the prompt reply. I'm new at Alteryx...

MRioux

[Boneckrh19]

Is there a way to nest the statements? I can't figure out the syntax because parenthesis do not work. I need something like:

(IsEmpty([Header1]) OR IsEmpty([Header2]))
OR
(!IsEmpty([Header1]) AND !IsEmpty([Header2]))

Is this possible in one Filter or do I need to do it in two separate Filters?

[Trumble_dup_334]

Bumping this thread as I have the same question as Boneckrh19. I have multiple criteria separated by ANDs checking different fields for specific values, and I need to add an additional that also excludes specific values based on the contents of 2 additional fields, without adding a separate Filter tool. Anyone have any ideas please?