topic Re: Is it possible to merge rows in an attribute table in ArcGIS Pro? in ArcGIS Pro Questions

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

VictoriaTousaw — Fri, 28 Jan 2022 20:00:25 GMT

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!

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

jcarlson — Fri, 28 Jan 2022 20:25:25 GMT

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.

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

DrewFlater — Fri, 28 Jan 2022 21:57:41 GMT

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

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

IlkaIllers1 — Fri, 04 Feb 2022 07:29:17 GMT

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.