Dissolve features and Concatenate text field values

1907
5
11-02-2018 08:35 AM
SaifulAlam
New Contributor II

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.

Tags (2)
5 Replies
NicolasSoenens
New Contributor II

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?

0 Kudos
NicolasSoenens
New Contributor II
0 Kudos
ShariForbes
New Contributor III

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. 

concatornate wtih dissolve.png

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!

JessicaCadieux
New Contributor

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?

JessicaCadieux_0-1692188630997.png

Thanks!

0 Kudos
SarahMarvin
New Contributor

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

0 Kudos