Filter using StartsWith and an Array of Phrases

hellyars

Hi,

I want to filter using STARTSWITH and an array of values. I tried this, but it does not work

!(StartsWith([HD], 'Notice|Policy|Transfer|Supplemental|Annex'))

Thanks!

Help

Expression

Accepted answers

jrgo

@hellyars

Alternate values don't work in most of the Alteryx functions other than with REGEX. You can either

NOT(
StartsWith([HD], 'Notice')
OR
StartsWith([HD], 'Policy'
OR
ETC...)

!REGEX_MATCH([HD], '^(Notice|Policy|Transfer|Supplemental|Annex).+$')

All comments

jrgo

@hellyars

Alternate values don't work in most of the Alteryx functions other than with REGEX. You can either

NOT(
StartsWith([HD], 'Notice')
OR
StartsWith([HD], 'Policy'
OR
ETC...)

!REGEX_MATCH([HD], '^(Notice|Policy|Transfer|Supplemental|Annex).+$')

Jonathan-Sherman

The first way that comes to mind would be to use Regex_Match:

Regex_Match([Values], '^(?:Training|Checking).*')

This would check for values starting with "Training" or "Checking" and would not be case sensitive. You could add more after "Checking" using a pipe | delimiter between. So for example a third would be:

Regex_Match([Values], '^(?:Training|Checking|Testing).*')

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200103 - MultipleStartsWith.yxmd

hellyars

@jrgo

Thanks. The REGEX expression worked.

!REGEX_MATCH([HD], '^(Notice|Policy|Transfer|Supplemental|Annex).+$')

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703