Hi All
I am trying to identify the best performing Dealership ID from a Group of Attributes. In Excel I would have used a Max If array formula, not sure how to best achieve this in Alteryx? grateful for any help
kind regards
Sid
Solved! Go to Solution.
Edit: When I saw @AbhilashR's post, I noticed I got the problem wrong. Go with his solution. (I won't adapt mine cause he was faster with the right solution and the credit belongs to him)
-----Original Post-----
hi @sghani87,
here is a way to do achieve this with Alteryx:
What happens:
1) Remove Dollar Sign
2) Remove Punctuation from the Revenue
3) Right data type
4) Get max per Dealership-ID
5) Join both back together
6) View the data
Output:
I'll attach the workflow. Let me know if it helps!
Regards
Alex
@sghani87 - Attached is an attempt to replicate the output you had in your .PNG file.
Let us know if this answers your question.
@grossal - you are too kind, Alex! 🙂
Thank you for coming back to me, much appreciated.