I am running a many-to-one join where I want the highest value to be joined to the input table. I set the merge rule as 'Maximum'. It is working for some features, but with a number of one-offs that are not applying the correct value.
This is a part of a model for future use with large data sets, so I want it to run correctly every time.
Original:
Result: