How to select the maximum value in a row

KK2

I would like to know if there is a way to find a maximum value in an attribute table in a row.

I have few columns representing different valuables of an object and I would like to know which variable has the highest value across all of them? Is there a ready to use function to do this? Thanks in advance for your answers.

NeilAyres

I don't know of an existing tool to do this.

You may want to try a little python, like this (btw completely untested)

<SPAN class="keyword token">import</SPAN> arcpy

pathtodata <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"c:/some/path/to/data/db.fgb/mydata"</SPAN>

flds <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"field1"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"field2"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"field3"</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>pathtodata<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> Cur<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> Cur<SPAN class="punctuation token">:</SPAN>
        minval <SPAN class="operator token">=</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">9999999</SPAN>
        minfld <SPAN class="operator token">=</SPAN> None
        <SPAN class="keyword token">for</SPAN> v <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>len<SPAN class="punctuation token">(</SPAN>flds<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN>v<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">></SPAN> minval<SPAN class="punctuation token">:</SPAN>
                minval <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN>v<SPAN class="punctuation token">]</SPAN>
                minfld <SPAN class="operator token">=</SPAN> flds<SPAN class="punctuation token">[</SPAN>v<SPAN class="punctuation token">]</SPAN>
        <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Fld {} min {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>minfld<SPAN class="punctuation token">,</SPAN> minval<SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>