AnsweredAssumed Answered

Join field with multiple fields included

Question asked by salmanseahmed on Jul 1, 2015
Latest reply on Jul 1, 2015 by cdspatial


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'?Untitled.png