Community
Select to view content in your preferred language

Table Help

58
1
yesterday
JulieAllsen
by
New Contributor
yesterday

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. 

 

1 Reply
Georgios-NektariosTselos
by
Regular Contributor
16 hours ago

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

0 Kudos