ModelBuilder Iterator overwriting results

BrandonLand

Hey guys, I think this is a simple question but not sure... I have a map with say, a counties layer and I want to make a tool that will count all the houses in each county (or selected counties) and output the results to a table.   So I have the tool, I put down an interator, passing in the selected counties to a clip function, that then passes the resulting houses into a stat box that counts them.   Problem is, I only get back the last selected county because the stat output overwrites the table with the last result.   How do I make it append or insert the results so I get them all back instead of just one?

curtvprice

You need to give the output tables a unique name using a model variable, ie:

out_table%n%.dbf

When you're done you can run the Merge tool to put them together. If you want to automate this process, you need to nest models and in the "outside" model, use the Collect tool to pipe that in to the Merge tool.

Hope this makes some sense. At least it's better than trying to iterate in 9.3!