Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Compare values from one column with another?

WillDCat
5 - Atom

I have a list of keywords in an Excel file. 

 

I need to create a workflow that uses the list of keywords to search through a large table and highlight every record in the table that mentions any of the keywords.

 

Keywords
Machine Learning
Greenhouse


Sample Data Set

Project IDProject Name
1001Coca Cola Pursuit
1002GNC Machine Learning Pursuit
1003Disney Greenhouse Machine Learning Deal
1004Yeti Machine Learning Deal
1005HP Record

 

Desired Output

Project IDProject NameMatches
1001Coca Cola PursuitNA
1002GNC Machine Learning PursuitMachine Learning
1003Disney Greenhouse Machine Learning DealGreenhouse, Machine Learning
1004Yeti Machine Learning DealMachine Learning

 

I've tried to use the find and Replace tool but this gets tricky when when one record matches more than one keyword.

 

Any help would be greatly appreciated!

2 REPLIES 2
BrandonB
Alteryx
Alteryx

How about this

 

BrandonB_0-1650304748886.png

 

 

Workflow is attached

WillDCat
5 - Atom

This is great, thank you!

Labels