Hi All,
I'm trying to build a logic using Alteryx but wanted some inputs on the tools that can be used. Some contacts are mapped to more than one registration as below. There are cases where two RIA's are mapped to a contact and one being Cambridge. The output should contain only one row where registration is RIA and firm name is Axiom and not Cambridge
Contact id Name Firm_Name Registration
1234 John Cambridge RIA
Axiom RIA
Cooper BD
Output:
Contact id Name Firm_Name Registration
1234 John Axiom RIA
Solved! Go to Solution.
Hi @aparna0208,
my workflow feels a bit wrong, because everything is "hardcoded" and it isn't dynamic, but it fulfills your request. Please be more precise if you want it to be more dynamic.
Output:
What happens:
- I use two Multi-Row-Formulas to fill up the columns
- Filter to extract the requested data
Workflow attached. Let me know what you think.
Best
Alex
How did you determine that you wanted Axiom and not Cambridge? From the data shown, the choice appears to be arbitrary.
Thanks for the quick response! @grossal This worked fine but I am just thinking of a way where nothing is hard coded. The reason that not in all cases the firm name will be Axiom. The situation is a contact will have more than one registration and Cambridge is one of the firm. So, I need to filer out the non Cambridge ones with RIA registration
Let us know when you have figured out some sort of rule to be implemented. We'll try to do our best to help you 😃
How about this? If there is only one RIA for a registrant, that will be returned. If there is more than one RIA, Cambridge will be eliminated. You will get multiple entries if there are two or more RIAs for a registrant and more than one is not Cambridge. You would have to add another filter to catch that.
It worked. I appreciate your help on this. Thank you very much:) @TonyA