community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More

Finding the minimum value of fields

Highlighted
Meteoroid

Looking to go from image 1 to image 2

Capture.PNGCapture2.PNG

Magnetar
Magnetar

Use a Summarize tool - group by Project, and select the Minimum of Score, then use Append fields to add that back to your data.

 

EDIT: Went too fast - Join instead of Append Fields so that the minimums come back appropriately, joining on Project

Pulsar
Pulsar

Hey @mham

 

Use a Summarize tool to get the minimum for each project. Lastly, use a Join tool to append the minimum score back to your original data set. 

 

Hope this helps!

 Capture.PNG

 

Edit: I had previously said use a Transpose first, but that is unnecessary, as shown above.

 

Pulsar

Here is the sample workflow for your case.  Hope this is helpful. 

 

Finding the minimum value of fields.PNGWorkflow

Labels