topic Re: Calculate Field tool not reading the Get Field Value in ModelBuilder Questions

Calculate Field tool not reading the Get Field Value

JssrRR — Thu, 23 Feb 2017 22:52:13 GMT

I am trying to calculate percent population using this model, it runs gives no error but the PctPop field is not giving the correct value, it just putting the SUM_POPULATION in place of calculating the percentage, as seen the table included in the image.

Also under current session, it has no results under geoprocessing, after the model runs, why is that?

Re: Calculate Field tool not reading the Get Field Value

ChrisDonohue__GISP — Thu, 23 Feb 2017 23:43:49 GMT

My first thought it that a Precondition may need to be established. Otherwise the Calculate Field might run before the Get Field Value. However, I am not certain that is what is causing the issue. Might be worth a try, though.

ArcGIS Help (10.2, 10.2.1, and 10.2.2) - A Quick Tour of Preconditions

ArcGIS Help (10.2, 10.2.1, and 10.2.2) - Setting Preconditions

Chris Donohue, GISP

Re: Calculate Field tool not reading the Get Field Value

ChrisDonohue__GISP — Thu, 23 Feb 2017 23:54:00 GMT

In terms of the issue with their not being results under geoprocessing, is the geoprocessing option checked? Go to: Geoprocessing, Geoprocessing Options..., check on "Log geoprocessing options to a log file".

Also, consider lengthening the time interval in section "Results Management" by "Keep results younger than:" Check this setting, as one of the options is "Never save".

Viewing tool execution history—Help | ArcGIS for Desktop

Chris Donohue, GISP

Re: Calculate Field tool not reading the Get Field Value

JssrRR — Fri, 24 Feb 2017 15:44:47 GMT

Chris,

Thanks for your quick response, as for checking the the geoprocessing options, I have it set at "Never Delete", tried again, still no results.

Re: Calculate Field tool not reading the Get Field Value

ChrisDonohue__GISP — Fri, 24 Feb 2017 16:22:18 GMT

To help in troubleshooting, can you post what the Get Field Value tool inputs look like? I.e. what is filled in here:

Chris Donohue, GISP

Re: Calculate Field tool not reading the Get Field Value

JssrRR — Fri, 24 Feb 2017 16:40:10 GMT

I tried after setting the precondition that you suggested, it is now calculating some value in PctPop, but not the correct percentage value, that I get using the field calculator

Re: Calculate Field tool not reading the Get Field Value

ChrisDonohue__GISP — Fri, 24 Feb 2017 20:28:49 GMT

Is the field "SUM_POPULATION" the sum of the counties population or the total population of the metro area? I ask as I see "SUM_POPULATION" in both the Calculate Field and Get Field processes, but don't see another field that would represent the other value. I may be missing something obvious, but it seems like we are missing one of the fields as an input needed to calculate the percentage.

Chris Donohue, GISP

Re: Calculate Field tool not reading the Get Field Value

ChrisDonohue__GISP — Fri, 24 Feb 2017 23:38:19 GMT

Another possibility in regards to the geoprocesing history being missing. If you are using ArcGIS 10.2, there apparently is a bug. NIM096145: When background processing is enabled, geoprocessing.. If this is the case, they do offer a workaround in that one can turn off the background processing and then the geoprocessing history will be retained. This issue may occur in other versions, though the bug report states it is fixed in 10.5

Chris Donohue, GISP

Re: Calculate Field tool not reading the Get Field Value

JssrRR — Sat, 25 Feb 2017 01:27:45 GMT

I am using ArcGIS 10.4x.

Thanks

Re: Calculate Field tool not reading the Get Field Value

JssrRR — Sun, 26 Feb 2017 18:19:38 GMT

Chris,

I have published geoprocessing services from the results window, after running a model, in this same version, before and it worked fine. It has to do with a tool or a setting in this particular model which is not sending results.

Re: Calculate Field tool not reading the Get Field Value

JssrRR — Sun, 26 Feb 2017 19:44:39 GMT

Chis,

I figured it out, I had to add another summary statistics and take the value from the first one and use the Calculate field with second table as an input and it gives me the percentages for each county in my Percent Population in the second table.