Text Mining (find all specified keywords within a cell and append all found to same field)

[achank1ns]

I'm wanting to text mine using a taxonomy but my company doesn't have the intelligence suite license for Machine Learning or Text Mining tools. After searching I came across an easy solution of using Find Replace but that seems to only want to find and replace the first instance when I want to find all keywords and append the same column with the words found using a delimiter. I thought by putting the Find Replace in a macro it would loop for all words but it didn't.

I would appreciate any help as I am very new to Alteryx and while I am usually good at Googling I can't seem to find an answer that doesn't involve the tools I don't have access to. 

File 1: Main Data Set:

Unique ID	Text
12345	I am so mad I don't know what I will do.
12346	I am beyond frustrated, this is ridiculous.
12347	I am so happy!!!
12348	This is unbelievable. How dare you do this to me, I will sue you!

File 2: Taxonomy:

mad

frustrated

ridiculous

unbelievable

dare

sue

Desired Result:

Unique ID	Text	Results
12345	I am so mad I don't know what I will do.	mad
12346	I am beyond frustrated, this is ridiculous.	frustrated; ridiculous
12347	I am so happy!!!	null
12348	This is unbelievable. How dare you do this to me, I will sue you!	unbelievable; dare; sue

[Qiu · Accepted solution]

@achank1ns 
I hope this would work for you.

[Garabujo7]

Hello @achank1ns ,

I think what you need is some regex

Attached you will find an example with the tokenize method that gets what you need.

Hope this helps

Gabriel

[achank1ns]

Thank you so much; this worked perfectly!!!

[Qiu]

@achank1ns 
Glad to help and thank you for the accept mark.