Keyword search for multiple words

[CRogers22]

Hello Everyone,

I'm trying to create a column and pull out keywords that match the "Text" from the input data.

Example:

Case	Text
K-283643	I cant complete this case due to incorrect dates.
K-836283	The case review has been complete with 3 fails.

the Keywords

Keywords

cant

incorrect

fails

I'm hoping to create an out put that does the following.

Case	Text	Keyword(s) Matched
K-283643	I cant complete this case due to incorrect dates.	cant, incorrect
K-836283	The case review has been complete with 3 fails.	Fails

Also if there is any possible way to highlight the keyword in the "Text" Column.

Thank you in advance for any help.

[ChrisTX]

For your Text column: try the Text to Columns tool, and choose the option to split the words to separate rows.  Then use a Join tool.

Check out the workflow attached to this similar post:  https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Match-short-phrases-with-long-...

Chris

[Raj]

@CRogers22 
one way of doing this 
mark done if solved.

[Qiu · Accepted solution]

@CRogers22 
Just play around with the tools.

[CRogers22]

Thank you all for the time!