community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Alteryx Equivalent of ACL Analytics Match

Highlighted
Meteor

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!

Aurora

Hi @JeremyN 

 

the Alteryx equivalent is IN

 

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

 

Dan

Labels