Table Help

JulieAllsen

I am working on a hydric soils layout, and I have a table showing the MUSYM and MUNAME attributes of the soils present on each page of my map series. I cannot figure out how to have not have duplicates of attributes that are the same.  I've tried to look up what I can do to fix this, and I'm currently trying to "concatenate" using "summary statistics", but it is taking forever, and I'm wondering if there is a better/easier way. 

 

Georgios-NektariosTselos

Hello @JulieAllsen , I suggest to you to try the following, 

1.Use the "Dissolve" Tool  :  

• Navigate to Geoprocessing > Dissolve.
• Set your input table or layer.
• Choose MUSYM and MUNAME as the "Dissolve Fields".
• This will remove duplicates and keep only one record for each unique MUSYM/MUNAME combination. 

2. Alternative: "Delete Identical" Tool: 

• Go to Geoprocessing > Delete Identical (this is very fast).
• Input your table or layer.
• Set the fields to MUSYM and MUNAME.
• It will delete all duplicate records with identical values in those fields. 

Kind Regards 

Nektarios