Regex Match and concatenating several rows

Hi everyone,

I've been reading about using Regex Match instead of using Contains when we have several words/references but I'm not able to make it work and I would like your help.

I have almost 200 words/references, one in each row. I concatenated them using the summarize tool with this configuration:

summarize tool config.jpg

and then use this formula:

formula tool.jpg

but it's not working. Any ideas? Thanks!

Regex

Accepted answers

Garrett_Stoker

Have you tried to use the Find Replace tool instead? You can feed it the list of words with a Boolean field that can be appended to the end of the output. See Example #4 in the Example workflow for Find Replace in Designer.

All comments

cpet13

@e168066 when you say it is not working, can you provide a little more detail? Is it not returning what you are expecting it to, is it giving you an error, etc.?

e168066

It's not working because it's not reading the word on the Concat_Field in the Corrective_Action field but I manually verified that the word is in there

cpet13

This post seems to provide some clues. Solved: Regex_match - Alteryx Community In the solution, the last field calculated, called Fullmatch, the author seems to be utilizing wildcards around what is being searched for. That might be what you need to do, insert wildcards around the Corrective_Action field in the REGEX_Match function. Screenshot 2024-10-28 141015.jpg

Garrett_Stoker

e168066

hey @Garrett_Stoker thank you for that! it totally worked!

@cpet13 Thank you for your help too! I was already using the wild cards when I was concatenating with the summarize tool but still didn't work.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335