Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Is it possible to create from Summarize option, a new table with the COUNT of a string field and the code of municipalities, in my case, like that:

+-------------------+--------------+
| id_municipalities | string_value |
+-------------------+--------------+
| 1                 | A            |
| 1                 | A            |
| 1                 | C            |
| 2                 | A            |
| 2                 | B            |
| 3                 | D            |
+-------------------+--------------+

And the result table, like that:

+-------------------+--------------------+---------------+
| id_municipalities | COUNT_string_Value |  string_value |
+-------------------+--------------------+---------------+
| 1                 | 2                  | A             |
| 2                 | 1                  | B             |
| 3                 | 1                  | D             |
+-------------------+--------------------+---------------+

Thanks in advance

share|improve this question

1 Answer 1

This uses the Summary Statistics tool rather than Summarize from the Attribute Table window but I think achieves the correct values - you may just need to re-order and delete some fields once you are satisfied the correct values are coming through.

enter image description here

share|improve this answer
    
Thanks, works perfectly! –  Marcello Benigno Dec 12 '12 at 12:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.