I have two questions regarding ModelBuilder.

  1. I have a point layer with Crop Yield values. I need to Add Field called "Count", then do a Calculate Field, Count = 1. The problem that I'm running into is that in Model builder, when I try to insert a Calculate Field tool, "Count" field does not exist yet so I cannot reference that. How do I get the Count field to appear in MB before running the Calculate Field operation?

  2. I need to do a Spatial Join in ModelBuilder as well. I have done a Multiple Buffer operation with 7 concentric circles, and I need to join each field (each "doughnut) in that layer with the points that fall within it. I then need to perform several operations including Sum, Min, Max, Std Dev. When I manually do a "right-click" Spatial Join (right click the layer itself and select Join), this is no problem. Here's the dialog I would like to see in Model builder:

enter image description here

However, the Spatial Join tool that is brought into ModelBuilder is significantly different. In it, you have the list of fields from the Join Feature, and you have to select an individual operation for each one.

enter image description here

Can someone tell me how to do this Join in ModelBuilder?

closed as too broad by PolyGeo Sep 10 '15 at 4:58

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Calculate Geometry function is used to calculate feature geometry (eg. area, x/y values...etc). Do you mean calculate field instead? – artwork21 Jan 22 '15 at 15:35
  • My mistake - yes that should be Calculate Field, not Geometry. – Johnsey Salt Jan 22 '15 at 15:36
  • 1
    As you will see in the Tour there should be only one question per question. – PolyGeo Sep 10 '15 at 4:59

You should be able to use the merge rules. By right clicking on the fields you want to analysis and going "Merge Rule", you'll be presented with the options for the merge. These options include First, Last, Join, Sum, Mean, Median, Mode, Min, Max, Standard Deviation and Count - Refer to the heading Merge rule in the link provided for more information. Also see example below

enter image description here

Additionally, there is information here which talks about "summarizing the data in your table" before joining the table that may assist further.


For your first question, make sure the add field object is created and connected to the feature class before the calculate field object.

  • Thanks for your assistance - this first question kind of resolved itself. It was acting quirky and finally, after multiple attempts, showed my Count field in the subsequent operation. However, I am still stumped by the second question. Anyone know how I can perform these summary operations in ModelBuilder? Thanks – Johnsey Salt Jan 22 '15 at 16:18

Not the answer you're looking for? Browse other questions tagged or ask your own question.