Select X number of columns and find the field that contains the largest

[ed_b]

I would like to select out of multiple fields the one that contains the largest value and output that field name as a new column. It is essentially an argmax() of multiple columns to return a field name for each row.

How may I go about this?

[MSalvage · Accepted solution]

@ed_b,

I think the solution to this revolves around the Multi field formula tool and the Function MaxIDX(). I have attached a rather "make shift" workflow that gets at what you want. There is probably a more elegant way of doing this, but this might get you started down the right track.

Hope it helps,

MSalvage

EDIT: Don't actually need the multi field formula the normal formula tool would do the same.

[Syarifhidayat]

hi @ed_b,

Take a look on my workflow.. if it not like what you want, tell me back. TQ