Replicate MINIFs function in Alteryx

[Andrew_Seaman]

I am given Column A and B in the below image and need to generate column C using Alteryx,

The logic for column C is to return a Y on the minimum value in B for each unique key in column A.  

I can create this using a minifs function in excel, and was trying to use a summarize tool to get this done.

[apathetichell]

attach a summarize tool. group by Key min Qtr. Then join back to your datastream on Key and Qtr. the data coming out of your join tool are the key's with min value for qtr.

OR. sort by both columns ascending. tile tool unique value on [key] the first tile sequence num (ie [tile sequence num] =1) will be the minimum value.