topic Re: Populating a field with a single value from a cell in your table. in ModelBuilder Questions

Populating a field with a single value from a cell in your table.

EricArscott — Wed, 18 Dec 2019 22:26:00 GMT

Hi there,

I have been trying to build a model that takes a maximum value from 1 field and inputs that value in a new field for every row. I have successfully extracted the max value from my "GRIDCODE" field and have joined this summary statistic back to the feature class as a new field titled "MAX_GRIDC" using "FID" 0 as the common class. However, this creates a field where only "FID" 0 has the "MAX_GRIDC" value and all other rows result in a value of 0. See photo below.

I want to populate the rest of the "MAX_GRIDC" field with the value in cell 1 of its field, in this example, 365. Is there an easy way to do this?

Thanks for your help!

Re: Populating a field with a single value from a cell in your table.

Anonymous User — Wed, 18 Dec 2019 23:53:41 GMT

Hi Eric,

You will have to use the iterators in model builder to calculate the field for each row of the table.

They should be hidden away in the toolbar/ribbon.

In Pro they are located in ModelBuilder(in the toolbar) -> Insert (in the ribbon) -> Iterators (hexagonal icon)

Hope this helps,

Michael

Re: Populating a field with a single value from a cell in your table.

curtvprice — Mon, 23 Dec 2019 15:13:50 GMT

Eric,

You have MAX_GRIDCODE in a one-row table (output of Summary Statistics I am guessing) and you want to populate it for the all rows in another table with this value, correct?

Instead of doing a join, extract the value out to a model variable using the Get Field Value tool and use the resulting variable in an expression in the Calculate Field tool to populate that field for the entire table.