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 |
