Luke Newman wrote:
summary statistics doesn't work for what i'm doing because the values in the table that i am trying to categorize are not numeric, the field in which i need the unique values contain different types of points of interest in Central London such as automotive, eating/drinking, tourism etc and I need to create a new table which displays a tally of each point of interest category. Thanks anyway.
|
The tool does exactly what you need, based on what you have described. A Frequency field counting all instances of a unique case value in the source table is always included in every record of the output and all field types (numeric, text or date) can be used as unique case fields. Text fields also can be used as summary fields if you want the Min, Max, First, Last or Count statistics for the text values. I use text fields in summaries all the time to get unique street name lists or summaries of text maintenance categories. The toolbox version is much better than the Table View context menu version you are probably thinking of, but even that version works to generate a count field for each unique text field value in a table list.
If you need this field combined with another field you can used the Summary Statistics tool to create a multi-field unique key value list with counts. This normally applies where you have broad categories in one field with more detailed subcategories in another field that could be repeated under more than one broad category. Multi-field keys cannot be joined back to another table using a Standard Join unless you concatenate the multi-field values into a new field in both the source and output. However, the Make Table Query tool can create multi-field joins and a Python cursor routine can also do multi-field matching.