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!
