Grabbing the cell NEXT to the (summarised) Min_Value

[arthurmauk]

Hi, I've got a table that looks somewhat like this:

Process	Rating	Name	Value
A	Major	X	5
A	Major	Y	3
B	Minor	Z	4
B	Minor	AB	2

I would like to result in something like this:

Process	Rating	Name	Min_Value
A	Major	Y	3
B	Minor	AB	2

where the Summarize tool is calculating the Minimum of the Value field, and the Name field is now taking the Name cell that is next to the minimum value(s) in the Value field. I tried Grouping by Name after the Min_Value but that just has as many records as there were before and I want less. How do I do this please? Thanks in advance.

[echuong1 · Accepted solution]

You can simply sort your records based on the value ascending to get the minimum value records ontop. I'd use the sort also on the process to group the values. From there, you can use the sample tool to grab the first record for each process.

[BrandonB]

You can use a summarize tool where you group by process and then find the min value. Then you join it back to your regular data on process and value so the only records that pass through are the ones that match the process and the minimum value from the process. Workflow attached!

 

[BrandonB]

@echuong1's solution is perfect if you only need one row for every process. If two or more rows correspond with the min value then you will want to take the join approach.