Adding an external field value in a Model Builder calculation

Question

I need to use the results of a geoprocessing workflow in a separate GP workflow calculation. I ran a TABLE_SELECT to create a table containing the required input values from the first GP model (top line of image below). I then wanted to use the GET_FIELD_VALUE function to extract the required value from the table and use this value in the CALCULATE_FIELD function of the second GP model (second line of image below). However, it does not "see" the field to be able include it in the calculation expression. I cannot find a way to  do this this. Any ideas? Thanks very much.

Mondi_GIS · Answer

Hi Scott, Thanks very much for your reply to my query regarding a Model Builder calculation. The first GP model actually creates an output table with the required fields so there is a table to be read. What I am not sure of is how to get the CALCULATE FIELD operation that is in the second, separate GP model to read this table and include one of the fields of the first GP model output in it’s expression? If I try and connect the output table to the CALCULATE FIELD Operator it only sees it as a precondition but does not read the actual table. Any ideas on this? Thanks again. Kind regards, Mark Mark Norris-Rogers GIS/Remote Sensing Specialist South Africa Division Mondi Mondi House 380 Old Howick Rd, HILTON 3245 P.O. Box 39, Pietermaritzburg 3200, KZN, South Africa Tel.: (+27) 033 329 5362 email: mark.norris-rogers@mondigroup.co.za www.mondigroup.com Mondi Limited 1967/013038/06 Experience Example 1.png

ScottMoyer · Answer

Mark,

If you're trying to write an expression for a field before that field exists, you can manually pre-create the field in the table and it will show up in your tool window. If you've already run your model you can add it to the appropriate table, or else pre-create the table with the needed field.

Scott

edlaanil_0-1644951147531.png