FAS Level Mapping Table

[jyeung753]

Hello, 

I am currently trying to develop a mapping table in alteryx which will help identify a variety of asset classes and assign them a correlating FAS level. 

(Ex. Warrant = "Level 1", Corporate Bond = "Level 2", Manager Priced = "Level 3", etc.)

Essentially the data I am receiving, gives all asset classes aside from cash a FAS level of 9. These all need to be replaced with their respective/correct levels.

I have tried using the Find Replace tool prior to trying to create a mapping table, however it seems I can't downstream the tool to assign more than one asset type a FAS level. It would be greatly appreciate if anyone has ever created a workflow for something similar. I have attached the sample data as a reference for what is being used for analysis. 

Thanks in advance!

[geraldo]

@jyeung753 

I don't know if I understand what you're looking for. But I made a workflow meeting some requirements that you placed for classification