topic Re: Dissolve features and Concatenate text field values in ArcGIS Pro Questions

Dissolve features and Concatenate text field values

SaifulAlam — Fri, 02 Nov 2018 15:35:56 GMT

I always wondered why ArcGIS doesn't have an option to concatenate text fields when using dissolve tool. This image is taken from another discussion:

Link for Discussion

The solution given at this discussion was a Spatial Join Tool and using field mapping. But the result was not as anticipated. It repeats every field value over and over, eventually fails because of field size.

It would be logical to have option in the Dissolve tool and using field mapping. Currently there is field mapping option but that is only for numbers.

Re: Dissolve features and Concatenate text field values

NicolasSoenens — Wed, 23 Feb 2022 15:29:08 GMT

I'm searching for the same problem at the moment.

I have different points with text that muyst be dissolved to the polygon.

Did you find the solution?

Re: Dissolve features and Concatenate text field values

NicolasSoenens — Wed, 23 Feb 2022 16:04:28 GMT

I found it in XLS

https://www.exceltactics.com/combine-data-multiple-rows-one-cell/

Re: Dissolve features and Concatenate text field values

ShariForbes — Thu, 22 Dec 2022 17:08:55 GMT

Hi SaifulAlam.

It is possible to dissolve and then concatenate those fields. For the Statistic Type choose Concatenate then you are able to specify the Concatenation Separator in my example I chose a semicolon. For the field you are concatenation you may also need to set up the Merge Rule too.

However, I would like to concatenate the last entered note as the first in the concatenation string so that's where I am having an issue.

Hope that helps!

Re: Dissolve features and Concatenate text field values

JessicaCadieux — Wed, 16 Aug 2023 12:24:13 GMT

Hi @ShariForbes ,

I don't have access to the option of indicating Concatenate as the Statistic Type.

Is there a functionality that you had to activate to have access to it?

Thanks!

Re: Dissolve features and Concatenate text field values

SarahMarvin — Sat, 23 Sep 2023 22:46:56 GMT

Can anyone help with this? I also need the concatenate option but it is not available in my version of Pro.