Alteryx Equivalent of ACL Analytics Match

[JeremyN]

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!

[danilang · Accepted solution]

Hi @JeremyN 

the Alteryx equivalent is IN

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

Dan