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

JamalNUMAN

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

DanPatterson · ‎08-09-2020

# ---- 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‍‍‍‍‍‍‍‍

JoshuaBixby · ‎08-09-2020

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?

ColeAndrews · ‎08-11-2020

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.

DanPatterson · ‎08-11-2020

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

ColeAndrews · ‎08-11-2020

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...

DanPatterson · ‎08-11-2020

see the link I added

JamalNUMAN · ‎08-12-2020

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

DanPatterson · ‎08-12-2020

It exists in existing toolsets

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

MajdoleenO_A__Awadallah · ‎08-16-2020

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

DanPatterson · ‎08-16-2020

As easy as 1,2,3 etcetera