Creating output table in Model Builder

Discussion created by xl36 on Jan 12, 2012
Latest reply on Mar 5, 2013 by gmtrucks
I have tens of thousands of points in a region. I divide the region into
over 2,000 sub-regional zones, and assign a zone ID to each point. I want
to calculate a spatial clustering score of the points in each zone. Using
Model Builder in ArcGIS, I build a model that has two major components:
"Average Nearest Neighbor" tool and "Iterate Feature Selection" tool. It
iteratively selects points by zone ID and calculates Nearest Neighbor Ratio
(NNRatio) for the points in each zone.

The results are just what I need. The problem is that I can only see the
results in the progress dialogue box on the screen with all sorts of
unwanted info (e.g. "processing begins ...") for each iteration. I really
need a way to get a clean output table that has zone ID and NNRatio fields.

I tried "Collect Values" tool. It can collect Zone IDs and NNRatios
(separately), but it doesn't create a file. Again, I can only view results
on the screen, although it is cleaner without all the other info on
processing progress.

Average Nearest Neighbor function has an option to export a HTML report.
But it is HTML, one file for each zone, and with a lot of unnecessary info
and graphics.

So my question is if there is a way to get an output table with zone IDs
and NNRatios.

Any help would be greatly appreciated.