check if description contains keyword from a list and flag it with a value

[tyreenugen]

Hi,

I have two excel files: 1) a list of records with a text description and 2) a list of keywords. I want to perform a search to see if any word from the keywords list show up in the description and if it does, flag it as "2" otherwise a "0". can someone advise on how this can be done in Alteryx?

[clmc9601 · Accepted solution]

Hi @tyreenugen,

Is this what you're going for?

 

[tyreenugen]

thank you so much! exactly what I needed. 

[christine_assaad]

Hi @tyreenugen 

Hope the attached helps. Cheers!