Model Builder and summarizing data

Question

Hi, 
I am using modelBuilder in order to automate many actions and it has been greate. Therefore there is a step where I need to summarizing a column RECNO in order to get sum of objects within each unique RECNO. The ArcToolbox Summary Statistics is not a right tool for this case. Does anyone can help me to insert summarizing function on modelBuilder?

hidekonagatani_feitoza · Answer

Thanks, Richard, I was missing the case field and really I got it. Thanks again.

RichardFairhurst · Answer

Hi, 
I am using modelBuilder in order to automate many actions and it has been greate. Therefore there is a step where I need to summarizing a column RECNO in order to get sum of objects within each unique RECNO. The ArcToolbox Summary Statistics is not a right tool for this case. Does anyone can help me to insert summarizing function on modelBuilder?

Summary Statistics is the perfect tool to do this.  I don't know why you think it wouldn't be.  It can use the RECNO field as a case field and then use whatever field you need to sum as a Summary field.  Make your original data a Layer or Table View with Make Feature Layer or Make Table View, and Join the summary result on the RECNO field to the source and Field Calculator the summary results to your original data.  You can even output the summary to an in_memory table if you don't want it stored on disk.

If you want spatial outputs you can use Dissolve to summarize your data into features.  Spatial Join can work in some cases.  Frequency is also available, but that requires an advanced license and I find Summary Statistics does everything Frequency does plus more.  Python can do this with a cursor and Model Builder could call the Python script.