topic Re: Calculate Field problem. in ModelBuilder Questions

Calculate Field problem.

Maximiliano_A_Bernal_Giraldo — Thu, 12 Jan 2017 16:17:11 GMT

Hi everyone, I'm making a model that basically selects the links that must change the value of one field, those links are selected by the proximity to the line feature, there are 108 line features thats why the iterator.

my problem is: the value that I have to put in the field is contained in each of the 108 features lines, with the tool get field I reach the value, but for some reason I don't know Calculate field tool do not recive the variable as a input, (only when the data type is variable or string it recives it, my value is double)

Can you please show me the problem to fix it ?

thanks

Re: Calculate Field problem.

ChrisDonohue__GISP — Thu, 12 Jan 2017 17:33:35 GMT

My very first thought would be that it is a casting issue. However, that's just a guess. Can you post a screenshot of what the Calculate Field Dialog box information is? I.e. what information was input. Can you provide a screenshot?

Chris Donohue, GISP

Re: Calculate Field problem.

Maximiliano_A_Bernal_Giraldo — Thu, 12 Jan 2017 17:59:15 GMT

Re: Calculate Field problem.

Maximiliano_A_Bernal_Giraldo — Thu, 12 Jan 2017 18:06:10 GMT

As you see because I can't make the conection between the output of "get field value" and "Calculate field" I can't assign the value to its corresponding field.

even further I think the main problem is Calculate field tool needs all the the values to fill the field are in the same table, and don't let they come from external sources, but it's just my opinion, perhaps it is a way I don't know.

Re: Calculate Field problem.

ChrisDonohue__GISP — Thu, 12 Jan 2017 19:31:43 GMT

What appears to be needed is a the use of an In-line variable in the Calculate Field tool so you can use the result of the Get Field Value. You will have to code this manually - it won't be available by pulldown. So in your Expression in the Get Field Value tool, it would look something like this:

fieldname = %Vel%

The key is the percentage symbols on either side of the variable. In the model you posted, the output of the Get Field Value was called Vel, so one can tap its value by using %Vel%.

From the Get Field Value tool help:

The Get Field Value tool gets the first value from a table of the specified field, and the value is then used as an in-line variable in the expression of the Calculate Field tool to find the percentage area of each polygon.

ArcGIS Help (10.2, 10.2.1, and 10.2.2) - Examples of Modelbuilder-only tools

ArcGIS Help (10.2, 10.2.1, and 10.2.2) - A quick tour of Inline Variable Substitution

Chris Donohue, GISP

Re: Calculate Field problem.

Maximiliano_A_Bernal_Giraldo — Thu, 12 Jan 2017 19:55:20 GMT

thank's man, it work

Re: Calculate Field problem.

ChrisDonohue__GISP — Thu, 12 Jan 2017 20:02:39 GMT

Glad to be of help.

Chris Donohue, GISP