Regex Match and concatenating several rows

[e168066]

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:

and then use this formula:

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

[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. 

[Garrett_Stoker · Accepted solution]

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.

[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.