nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is it possible to merge rows in an attribute table in ArcGIS Pro?

VictoriaTousaw

I joined a table to a polygon feature class. The table contained multiple rows of data for each polygon. I am trying to find a way to combine the data from the multiple rows into one row, ideally creating a list, separated by commas for each field.

I have tried merging the file (using field mapping to join with a ', ' delimiter for the fields I am trying to combine data in), this output is identical to my initial data. I don't think the merge tool will merge multiple rows together, only multiple fields. I tried using dissolve, but again the output is the same as the input. I don't think this is the right tool either as I am not combining rows with the same data.

Any ideas are appreciated!

Encuentra más publicaciones etiquetadas con

Accepted answers

DrewFlater

This kind of "merging" of multiple rows is typically done in the Summary Statistics tool, but there is not yet an option for concatenating values with a delimiter, though there is an enhancement logged that you can track ENH-000133689, also please comment and vote on the ArcGIS Ideas site: https://community.esri.com/t5/arcgis-pro-ideas/arcgis-pro-2-6-a-geoprocessing-tool-to-concatenate/idi-p/941105

All comments

jcarlson

There is a Merge editing tool that can merge two records of a layer.

https://pro.arcgis.com/en/pro-app/latest/help/editing/merge-features-into-one-feature.htm

Word of caution: what this does to your attributes depends on the split/merge policy in place on the dataset. You may have to do a bit of prep work to ensure that the output values of the merge are correct.

DrewFlater

IlkaIllers1

In these cases I first use dissolve, and then input the dissolved fc into a spatial join, join one-to-one. Setting the fc with multiple entries as the join class, you can set the merge rule for the field that should list all the different values to "join" and use a comma as delimiter. Now you have a fc with one entry per polygon that lists all values of the field.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.