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

Alteryx Equivalent of ACL Analytics Match

JeremyN
8 - Asteroid

I have an ACL Analytics script that is creating a new field and uses ACL's MATCH function to compare a field to multiple string values (ex. MATCH(FIELD, "STRING1", "STRING2", "STRING3")).  Is there a similar function within Alteryx?  I could achieve this result with a series of OR statements (ex. FIELD = "STRING1" OR FIELD = "STRING2" OR FIELD = "STRING3") but would like to know if there is a more concise way.

 

Thanks!

1 REPLY 1
danilang
19 - Altair
19 - Altair

Hi @JeremyN 

 

the Alteryx equivalent is IN

 

[FIELD] IN ( "STRING1", "STRING2", "STRING3")

 

Dan

Labels