IF Statement - Is value within predefined list

[HSuffolk]

Hi all

I'm trying to incorporate a static defined set of values into an IF statement.

An illustrative example would go something like: IF [Field Name] CONTAINS {G11,G12,G13,G14,G15,G16,G17} THEN "Yes" ELSE "No" ENDIF

Is this possible? Is Alteryx able to work through a set of values in this way?

Thanks

H

[atcodedog05 · Accepted solution]

Hi @HSuffolk 

Here is how you can do it. Add new value in the bracket as |G18

Workflow:

Hope this helps : )

[messi007]

@HSuffolk,

Another way how you can do it

Attached the workflow,

Regards,

[HSuffolk]

Thank you for the responses. I've used the RegEx_Match and it works great.

Secondary question - is there a way to incorporate a dynamic list instead of defining G11, G12, etc? A reference to a list of values that calculate elsewhere in the workflow perhaps?

Thanks

H

[atcodedog05]

_

[atcodedog05]

Hi @HSuffolk 

You can do something like this.

Workflow:

Hope this helps : )