topic Re: Unexpected Frequency Tool Results in Geoprocessing Questions

Unexpected Frequency Tool Results

JoePlattner — Thu, 22 Jan 2015 19:22:45 GMT

Curious if anyone else has ever had this happen. . . .

After running this tool against a field in one of my feature classes, I expect to see a count for every unique value within that field in a new table.

What I have been seeing is while it does return a count many values are listed multiple times.

In the example below I'm running it against the COMPKEY field, If it was working the way I expect the value 0 should only appear once. Maybe I don't understand the way this tool works, but it's strange. fyi - this is using arcmap 10.2.1

Re: Unexpected Frequency Tool Results

SolomonPulapkura — Thu, 22 Jan 2015 19:27:24 GMT

Maybe there are spaces in front of the 0's...

Re: Unexpected Frequency Tool Results

JoePlattner — Thu, 22 Jan 2015 20:16:18 GMT

Thanks Solomon,

That could be it, but don't know how. The field I'm trying to run the frequency against is a long integer field. Is it possible for spaces to get inserted before a zero in a long integer field?

Re: Unexpected Frequency Tool Results

AkosKisreti1 — Mon, 02 Feb 2015 13:37:20 GMT

Hi Joe,

you can try the summarize command. Right-click on COMPKEY field in your original table and create the table. I think you will have the correct frequencies.

I can't explain it to you but I have encountered the same problem.