topic Re: Model Builder and Summary Statistics - output 1 table in ModelBuilder Questions

Model Builder and Summary Statistics - output 1 table

LubicaCverckova2 — Thu, 15 Mar 2018 19:49:00 GMT

I need to collect SUM of one field (Length) on five different feature classes. I set up an iterator in model builder which goes through all the feature classes to Summary Statistics. The problem is the output table only contains the SUM value of the last feature classes. I was hoping the table to have all five SUM values for each class.

This is how my builder model looks like along with output table showing only one row:

Any ideas how to populate all five values?

Re: Model Builder and Summary Statistics - output 1 table

curtvprice — Thu, 15 Mar 2018 22:20:48 GMT

Uniquely name your outputs with the iteration # like this:

out_stats%n%

This will create output tables out_stats0, out_stats1, etc. as the model runs. You can then append these together to get your result.

If you want to batch this to do the append step automatically, you need to collect the results with a Collect Values tool and set as an output parameter, then embed your model in a new "master" model which takes the collected results as a parameter to the Merge tool. There are examples in the help of nesting models:

A quick tour of advanced techniques in ModelBuilder—Help | ArcGIS Desktop

Re: Model Builder and Summary Statistics - output 1 table

ChrisDonohue__GISP — Thu, 15 Mar 2018 22:35:11 GMT

Curtis Price has the answer. To add to it, if you are interested with what the % % signs are for, check out this subject:

A quick tour of using inline variable substitution—Help | ArcGIS for Desktop

Examples of inline model variable substitution—Help | ArcGIS for Desktop

Examples of in-line variable substitution with ModelBuilder system variables—Help | ArcGIS for Desktop

Chris Donohue, GISP