idea ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table, in ArcGIS Pro Ideas

ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

JamalNUMAN — Sun, 09 Aug 2020 08:14:08 GMT

ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

It would be great if we got an out of the box geoprocessing tool that concatenates values of a table. I’m aware of that such tool could be available but I wanted this tool to be built in in the Pro

In the screenshot below, the result of concatenation of attribute table P1 is represented in the stand-alone table T3

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

DanPatterson — Sun, 12 Dec 2021 11:53:41 GMT

# ---- it is called Calculate Field or the field calculator
# ---- no need to type the field names, just select them

f"{!Locality!}, {!Type!}" # ---- option 1

({}, {}".format(!Locality!, !Type!)  # ---- option 2

!Locality!} + ", " + {!Type!}  # ---- option 3‍‍‍‍‍‍‍‍

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

JoshuaBixby — Sun, 09 Aug 2020 17:38:37 GMT

Although concatenation isn't about statistics, I think expanding Summary Statistics functionality to support concatenation of string/text fields makes more sense than creating a whole new tool. In Python and many other programming languages, the same "+" that is used to sum numerics is also used to concatenate text, so why not have Summary Statistics sum text?

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

ColeAndrews — Tue, 11 Aug 2020 21:58:23 GMT

Dan Patterson‌, the idea is proposing a GP tool with a new output that has less rows than the input. Field calculator doesn't solve this.

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

DanPatterson — Tue, 22 Jun 2021 09:00:35 GMT

Can't be done in a gdb, you can concatenate into a new field and delete the old ones. The extra effort to do this doesn't warrant bulging the Pro code base, when simple workflows already exist

It sort of falls into the category of this Idea

https://community.esri.com/ideas/3495

which won't get implemented

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

ColeAndrews — Tue, 11 Aug 2020 22:15:01 GMT

You lost me. This can easily be accomplished with a GP tool, I can do it in modelbuilder already. The request is just for it to be packaged as an out of the box GP tool...

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

DanPatterson — Tue, 11 Aug 2020 22:17:30 GMT

see the link I added

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

JamalNUMAN — Wed, 12 Aug 2020 08:54:54 GMT

Correct Cole. What I wanted by this idea is to have this tool as an out of the box.

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

DanPatterson — Wed, 12 Aug 2020 16:15:09 GMT

It exists in existing toolsets

https://community.esri.com/docs/DOC-14928-free-tools-for-arcgis-pro-table-tools

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

MajdoleenO_A__Awadallah — Sun, 16 Aug 2020 09:20:34 GMT

Hi DAN,

May you please explain more how to use these codes, applying calculate feild tool does not end with the required results.

Best

Majdoleen

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

DanPatterson — Sun, 16 Aug 2020 09:30:09 GMT

As easy as 1,2,3 etcetera

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

MajdoleenO_A__Awadallah — Sun, 16 Aug 2020 09:38:04 GMT

Yes, I got the same results as you!! but this is not our case, I want it to concatenate all the values the got the same type in one row, in your case, it writes the locality, type!! please have a look on the attached photos provided by Jamal!!

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

DanPatterson — Sun, 16 Aug 2020 09:50:25 GMT

That is a "summarize" operation

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

MajdoleenO_A__Awadallah — Sun, 16 Aug 2020 10:01:00 GMT

Summarize only count the number and does not concatenate all the values in one row!

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

ColeAndrews — Tue, 18 Aug 2020 20:27:06 GMT

In my opinion, the misunderstanding across this thread is due to the title. "Concatenate values of a table" sounds like what Dan Patterson is trying to answer, but that's not exactly the request. You have to actually look at the pictures to understand the request.

I would suggest either revising the title. I'm not sure if you can do that, or if Kory Kramer has to. As Joshua Bixby stated, I would consider this an enhancement to the summary statistics tool or the pivot table tool. "expanding Summary Statistics functionality to support concatenation of string/text field"

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

JamalNUMAN — Thu, 20 Aug 2020 11:07:40 GMT

Thank you for the input Cole.

Correct. Sometimes words fail to explain the idea. This is why I support my words with screenshots to precisely describe the idea.

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

DuncanHornby — Sun, 12 Dec 2021 11:53:44 GMT

As Cole and Dan indicate this can be done as a fairly simple python script which you could wire up as a tool and then you would have your tool! I put together the code for you, it is below:

The code is designed to be run from the python script window in ArcPro but with not much effort could be turned into a tool that you could drag 'n' drop into modelbuilder.

Hope it helps

# -*- coding: utf-8 -*-
"""
Title:  Group and Concatenate into table

Usage:  Edit inputs and run this code in Python window in ArcPro.

Author: Duncan Hornby

Created: 21/8/20
"""
import arcpy
from collections import defaultdict as dd
d = dd(list)
arcpy.env.overwriteOutput= True

# Inputs
fLayer = "fcTest"          # The layer in your TOC
outPath = r"c:\scratch"    # The output table path
outName = r"testOut.dbf"   # The output table name
fullPath = outPath + "\\" + outName
fields = ["local","type"]  # field to concatenate is local grouping by type
outFields = ["Type","Locality"] # Fields in output table

# Create the group and concatenation
with arcpy.da.SearchCursor(fLayer,fields) as cursor:
    for row in cursor:
        loc = row[0]
        typ = row[1]
        d[typ].append(loc)

# Create output table
arcpy.CreateTable_management(outPath,outName)
for fn in outFields:
    arcpy.AddField_management(fullPath,fn,"TEXT",None,None,50)
    
# Write results to table    
with arcpy.da.InsertCursor(fullPath,outFields) as inCursor:
    for k,v in d.items():
        commastring = ','.join(v)
        row = (k,commastring)
        inCursor.insertRow(row)
        
# Finished!
print("Finished!")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

JamalNUMAN — Mon, 24 Aug 2020 07:56:08 GMT

Many thanks Duncan,

My point here is trying to suggest adding as many basic tools as possible to be out of the box so that they got available with the software installation.

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

KoryKramer — Wed, 09 Sep 2020 15:40:32 GMT

We've entered [ENH-000133689: Expand Summary Statistics functionality to support concatenation of multiple string/text fields.] into our support system. I associated this idea with that request, but if anybody is interested in being attached directly to the enhancement request, you can contact technical support.

The current thinking is that this will not be summing text, rather joining the string fields using a delimiter specified by the user.

Re: ArcGIS Pro 2.6: A geoprocessing tool to concatenate values of a table,

JoshuaBixby — Wed, 09 Sep 2020 17:40:05 GMT

Thanks Kory.