Preparation - Custom Filters (A AND B) OR (C AND D)

[Leanna12]

Description of Process	In the custom filter tool, I want to write an expression that says something along the line of (Column 2=48040 AND Column 1 Contains QZ)  OR (Column 2=50786 AND Column 1 Contains QZ) OR (Column 2=51939 AND Column 1 Contains QZ Can this be done with one expression or do I need to make two filters? Can you help me with a sample workflow for this?
Description of Input	Two Columns
Description of Output (DESIRED OUTPUT)	see above

[Luke_C]

Hi @Leanna12 

You could try this filter configuration, using the 'In' operator

[Column 2] in(48040,50786,51939) and contains([Column 1],'QZ')

[Amilley]

@Leanna12  You could absolutely use your logic in a very simple compound statement:

To that point @Luke_C's solution would work as well, but may be less readable for those not familiar with the 'value IN' function - on the plus side, its more tight, and if you needed to add another condition, you could just expand the list in the IN clause - so there is some continuity there!

Hope that helps!