6

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             |
+-------------------+--------------------+---------------+
9

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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