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

Using the Custom Filter to filter out multiple criteria

JeniferReid1
6 - Meteoroid

I would like to update the formula below to include any records where the Job Title is "Director" in addition to the "Manager" job title which is included below. I am not sure what the correct syntax would be to include the "Director".

 

IF

contains([Job Family Group],"Sales")
AND
contains([Job Title],"Manager")

THEN 'false'
ELSE 'true' ENDIF

3 REPLIES 3
Emil_Kos
17 - Castor
17 - Castor

Hi,

 

you can try:

 

IF

contains([Job Family Group],"Sales")
AND
contains([Job Title],"Manager") OR contains([Job Title],"Director")

THEN 'false'
ELSE 'true' ENDIF

 

there is also formula IN but i dont have access to Alteryx now to Check it. 
with it you could replace this part:

 

 contains([Job Title],"Manager") OR contains([Job Title],"Director")

Qiu
20 - Arcturus
20 - Arcturus

@JeniferReid1 

Sample workflow based on the idea of @Emil_Kos 

Capture1A.PNG

JeniferReid1
6 - Meteoroid

Thank you - that worked!

Labels