Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Highest / Lowest Flag when Multiple and No Values Apply

kheuer
8 - Asteroid

I am preparing a price analysis amongst multiple companies. I want to identify which company offers the lowest and the highest price. I have scenarios where multiple companies offer the same price and in these cases I want both companies to be flagged. I also have companies that do not offer a price at all, in that case I want them to be flagged with a zero. 

 

The workflow I have built is too complex at the moment with various transposes, sums, joins and formula tools. I know that there must be a better/easier solution out there. Your ideas are greatly appreciated.

 

Flags.png

2 REPLIES 2
mpennington
11 - Bolide

I think this does what you are looking for.  Summarize tool for the matches, join it back and calculate the matches with a formula tool.

 

Price.png

 

 

kheuer
8 - Asteroid

Yes!!! This is perfect. Thank you so much.

Labels