AnsweredAssumed Answered

problem "summarize" tool

Question asked by dmasana on Feb 2, 2016
Latest reply on Feb 2, 2016 by xander_bakker

 

code polygon
% coverfragility
a504
a155
a352
b1005
c201
c803

d

1003
e602
e404

 

I have to summarize the "code polygon" so that from the various entrys corresponding to the same code, it only remains the one with highest "%cover". When you use the summarize tool, for each of the fields of the output table you have to choose which parameters you want to appear. But in this case I would like that the "fragility" value in the output table corresponds to the one in the same entry as the highest "%cover" value. The output table would have to look like this:

 

code polygon% cover
fragility
a504
b1005
c803
d1003
e602

 

Since I have several thousand entries in my input table, could anyone help me find a way to do this authomatically?

 

Thanks in advance

Outcomes