Summary Statistics tool returns empty table

3625
4
05-28-2015 08:58 AM
RogerDunn
Occasional Contributor II

I was trying to help a user this morning with the Summary Statistics tool.  The user as one specified Statistic field, which is an Integer, and two specified Case fields (one is an Integer and the other is a Float).  No matter what I try, the resulting table is always empty.  There are no selected records in the source table, and the source table is a feature class from a file geodatabase.

0 Kudos
4 Replies
DarrenWiens2
MVP Honored Contributor

Can you provide a screenshot of your tool dialog?

0 Kudos
SepheFox
Frequent Contributor

Hi Roger, I'm not clear why you would you use a float field as a case field. Generally some kind of categorical field  is used as the case, since you want to return summary results for each unique value, or combination of values in your instance. Perhaps it will become clear after you post a screenshot.  A general explanation of what the user is hoping to achieve would also be helpful.

0 Kudos
JonathanGillespie
New Contributor II

Hi Roger,

While not specific to your problem, I've had similar problems with empty results from various tools and often the problem stems from incorrect formatting or illegal characters somewhere in the attribute table.

Definitely worth checking.

curtvprice
MVP Esteemed Contributor

Jonathan is right on there.

Table and field names should start with a letter, only have chars: [a-z][0-9]_

Field names should be short if possible (<10 chars)

This often causes problems because the software lets you use all kinds of crazy names and everything seems fine until you get to the one tool or workflow you need to get your answer!

0 Kudos