Multiple Filter and Tagging the data with speific

[jerry2]

Hi Everyone, I am pretty new to Alteryx. I have a quick question about multiple filter tagging. I have report that generates monthly that has a missing column in the data set. There are multiple columns of data that need to be filtered to find key words so that i can tag the information. For Example, There is a row in my data set, i need alteryx to go look for key words from my lookup table first in the Description column if found tag appropriately, if not go to the Service Type column if found tag appropriately, if not go to the Partner column and tag appropriately. What is the best way of doing this. I want to try and avoid formulas as much as possible for streamline purposes. 

Data Set

Description	Service Type	Partner
Joe SAP	Plumbing	SAP _AG
Dan MS	Construction
Phil Alteryx	Trucking	Alteryx
Joe (Hanna)	Trucking

  Lookup Table

Lookup Table	Tag
Hanna	SAP
SAP	SAP
MS	Microsoft
Microsoft	Microsoft
Hanna	SAP
Alteryx	Alteryx

 FInished Data Set

Description	Service Type	Partner	New Tag Column
Joe SAP	Plumbing	SAP _AG	SAP
Dan MS	Construction		MS
Phil Alteryx	Trucking	Alteryx	Alteryx
Joe (Hanna)	Trucking		SAP

[CarlDi]

hi @jerry2

I attached a workflow that can help you get started. A Find Replace tool might be the best bet.

Hope that helps!

[danilang · Accepted solution]

hi @jerry2

@CarlDi's solution is a good start, but it only parses the Description column.  Here's an expanded version that parses the 3 columns in turn and tags the rows that have not yet been tagged.  Note that I added new data rows to your sample and new lookup rows to the table to handle all the cases  In your initial data set all the rows were tagged using the Description column so the extra columns were never referenced

Dan

[jerry2 · Accepted solution]

Thank you this did help my Data set