BUG

The Dissolve tool returns incorrect results when a Text field contains uppercase and lowercase values

Last Published: April 25, 2020

Description

**This bug has been fixed at ArcGIS 9.3.**

The Dissolve tool returns incorrect results when the dissolve field is text, and contains uppercase and lowercase values.

Cause

This is a known issue in ArcGIS 9.0, 9.1, and 9.2 releases.

Workaround

If the values of the field do not need to be uppercase and lowercase, edit the field values to make the case of the values consistent.

If the case needs to be upper and lower, follow the steps below to perform a Summarize on the dissolve field of the original dataset.

  1. Add a new field.
  2. Define the field as a Short or Long Integer and name the field DissolveB.
  3. Join the origin dataset to the destination dataset, based on the original dissolve field, DissolveA.
  4. Calculate the origin.DissolveB field to be equal to destination.OID.
  5. Remove the Join.
  6. Run the dissolve based on the DissolveB field.

Article ID: 000007185

Software:
  • ArcMap 9 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options