I have 3 fields a, b, c in the join feature class. I want to join using field a, calculate statistics using field b, but also want to include field c in the final table to show value corresponding to the statistic value selected from field b. For example in the image I want to dissolve by 'Sub_Region', calculate MAX statistic by 'Result' but also want to see 'Sub_Regi_1' value. In case of 'Sub_Region' 1 I want to see 12.399698 in 'Result' and 39 in 'Sub_Regi_1'. With dissolve I only get 'Result'. How can I also get 'Sub_Regi_1'?
If one Dissolves by the field "SubRegion" the results from the field "Sub_Regi_1" will be lost. For example, in the table image posted, Dissolving all of Sub_Region = 1 will essentially collapse the 4 records to one.
One potential way to get around this is to do any calculations before doing the Dissolve. You could iterate through the values of "SubRegion" (using Modelbuilder or Python) and do the necessary calculations, the results of which could be placed in new fields. Then do the Dissolve. You may have to join back the table with your calculations to the feature class result of the Dissolve (using "SubRegion" as the key).
Chris Donohue, GISP