have encountered a problem, in Field Calculator.
The situation : I have a polygon feature with a table, comprised of a single Field ("Field1"). There are 675 records in this field. The minimum value is 0.24, and the maximum value is 2546.
What I want to do: Add a new field ("Field2"), in which I want to generate the normalized values in "Field1". By normalization, I am referring to re-scaling all the values, from 0 to 1.
What functions / expression can I use in Field Calculator, to obtain these normalized values?
Best Answer
Using Python would open up some more elegant solutions, but you can do this entirely in ModelBuilder with the use of a couple of temporary tables. The model would look something like this (note that you can right-click on any process step and rename it):
(([Field1] - %Min_Value%) / (%Max_Value% - %Min_Value%))