IF Statement - Is value within predefined list

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

Tips and Tricks

Accepted answers

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

Workflow:

Hope this helps : )

All comments

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

Workflow:

Hope this helps : )

Another way how you can do it

Attached the workflow,

Regards,

Replace_20210930.yxmd

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

_

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15874

MarqueeCrew 13708

apathetichell 13703