{"id":179091,"date":"2012-07-05T23:28:34","date_gmt":"2012-07-05T23:28:34","guid":{"rendered":"http:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&p=179091"},"modified":"2018-12-18T11:30:51","modified_gmt":"2018-12-18T19:30:51","slug":"concatenate-row-values","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values","title":{"rendered":"Concatenate Row Values"},"author":4041,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341],"tags":[24321],"industry":[],"product":[36991],"class_list":["post-179091","blog","type-blog","status-publish","format-standard","hentry","category-analytics","tag-geoprocessing","product-arcgis-desktop"],"acf":{"short_description":"Learn more about concatenating field values from this blog","flexible_content":[{"acf_fc_layout":"content","content":"
\n
\n

In a table you can concatenate\u00a0field values\u00a0<\/strong>or\u00a0row values<\/strong>.<\/p>\n

Concatenating field values<\/strong>
\nLearn more about concatenating field values from this\u00a0blog<\/a>.<\/p>\n

Concatenating row values<\/strong>
\nDownload the script tool from\u00a0here<\/a>. This tool is based on a python script that takes an input table, selects a row(s) based on a field value, and concatenates the row values of any other specified field. This tool does not create a new output, but updates the input data.<\/p>\n

<\/span>Example of using Concatenating Row Values tool<\/strong>
\nUsually, in field sampling data a single point (e.g. the center or the intersection of a quadrant) is linked to an area in the field, and the data recorded for each species (grass\/shrubs vegetation) within the quadrant is added as a separate entry linked to the same point as shown below:<\/p>\n

\"\"<\/p>\n

This data has multiple records for the same center point\u00a0\"\"\u00a0of the quadrants. In such cases, if you want to concatenate the vegetation values for the same quadrant you can run the\u00a0Concatenate Row Values<\/a>\u00a0tool (as shown below):<\/p>\n

\"\"<\/p>\n

After concatenating the row values, you don\u2019t need all the multiple points because one point has all the information you need (the All_Vegetation field). The\u00a0Delete Identical<\/a>\u00a0tool can then be used to delete all but one of the multiple points (as shown below):<\/p>\n

\"\"<\/p>\n

This workflow is shown below in a simple model:<\/p>\n

\"\"<\/p>\n

Since both the tools modify the input, creating a backup copy of the input is strongly recommended.<\/p>\n<\/div>\n

This entry was posted in\u00a0Analysis & Geoprocessing<\/a>. Bookmark the\u00a0permalink<\/a>.<\/div>\n<\/div>\n
\n
Enhancements to creating features with templates in ArcGIS 10.1<\/a><\/div>\n
Simplified management of user privileges @ 10.1<\/a><\/div>\n<\/div>\n
\n
\n

Leave a Reply<\/small><\/h3>\n

You must be\u00a0logged in<\/a>\u00a0to post a comment.<\/p>\n<\/div>\n

49 Comments<\/h3>\n
    \n
  1. \n
    \n
    nadinewazen<\/cite>\u00a0says:<\/span><\/div>\n
    \n

    Thank you this is a very helpful tool.
    \nI used it to concatenate values in English and it worked just fine.
    \nHowever I am having a problem using it to concatenate values in Arabic.
    \nI am getting the following error:<\/p>\n

    Executing: ConcatenateRowValues22 Union_Munip_Concatenated Union_Na_1 Short_Name VillagesAr \u201c, \u201d
    \nStart Time: Mon Apr 02 12:11:14 2012
    \nRunning script ConcatenateRowValues22\u2026
    \nPYTHON ERRORS:
    \nTraceback Info:
    \nFile \u201cC:Documents and SettingsNadineMy DocumentsArcGISNW_DB_UN_HabitatConcatenateRowValues10ScriptsConcatenaterowvalueArc.py\u201d, line 106, in
    \nvalue = str(lastvalue) + Delimiter + str(value)<\/p>\n

    Error Info:
    \n: \u2018ascii\u2019 codec can\u2019t encode characters in position 0-4: ordinal not in range(128)<\/p>\n

    ArcPy ERRORS:<\/p>\n

    Completed script ConcatenateRowValues22\u2026
    \nFailed to execute (ConcatenateRowValues22).
    \nFailed at Mon Apr 02 12:11:15 2012 (Elapsed Time: 1.00 seconds)<\/p>\n

    If I got it right the problem is in the fact that Arabic is not encoded in ASCII. Is there a way to modify the script to make it identify it as UTF-8?<\/p>\n

    Would appreciate any help i can get,<\/p>\n

    Thank you !!<\/p>\n<\/div>\n<\/div>\n<\/li>\n<\/ol>\n<\/div>\n"}],"authors":[{"ID":4041,"user_firstname":"Shitij","user_lastname":"Mehta","nickname":"Shitij Mehta","user_nicename":"shitijmehta","display_name":"Shitij Mehta","user_email":"smehta@esri.com","user_url":"","user_registered":"2018-03-02 00:15:39","user_description":"Shitij is the product owner for ModelBuilder in ArcGIS Desktop and leads ModelBuilder efforts in web environments at Esri. She oversees the full product lifecycle\u2014from feature design and development to testing and refinement\u2014ensuring a seamless experience for users. Beyond the office, Shitij is a Heartfulness meditation trainer, dedicated volunteer, and passionate researcher focused on tigers and elephants.","user_avatar":""}],"related_articles":"","card_image":false,"wide_image":false},"yoast_head":"\nConcatenate Row Values<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Concatenate Row Values\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-18T19:30:51+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values\"},\"author\":{\"name\":\"Shitij Mehta\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e535f780f7b06cceac95bb5b8a079f16\"},\"headline\":\"Concatenate Row Values\",\"datePublished\":\"2012-07-05T23:28:34+00:00\",\"dateModified\":\"2018-12-18T19:30:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values\"},\"wordCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"geoprocessing\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values\",\"name\":\"Concatenate Row Values\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2012-07-05T23:28:34+00:00\",\"dateModified\":\"2018-12-18T19:30:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Concatenate Row Values\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e535f780f7b06cceac95bb5b8a079f16\",\"name\":\"Shitij Mehta\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/10\/SM.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/10\/SM.png\",\"caption\":\"Shitij Mehta\"},\"description\":\"Shitij is the product owner for ModelBuilder in ArcGIS Desktop and leads ModelBuilder efforts in web environments at Esri. She oversees the full product lifecycle\u2014from feature design and development to testing and refinement\u2014ensuring a seamless experience for users. Beyond the office, Shitij is a Heartfulness meditation trainer, dedicated volunteer, and passionate researcher focused on tigers and elephants.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/shitijmehta\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Concatenate Row Values","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values","og_locale":"en_US","og_type":"article","og_title":"Concatenate Row Values","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2018-12-18T19:30:51+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values"},"author":{"name":"Shitij Mehta","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e535f780f7b06cceac95bb5b8a079f16"},"headline":"Concatenate Row Values","datePublished":"2012-07-05T23:28:34+00:00","dateModified":"2018-12-18T19:30:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values"},"wordCount":3,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["geoprocessing"],"articleSection":["Analytics"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values","name":"Concatenate Row Values","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2012-07-05T23:28:34+00:00","dateModified":"2018-12-18T19:30:51+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/analytics\/concatenate-row-values#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Concatenate Row Values"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e535f780f7b06cceac95bb5b8a079f16","name":"Shitij Mehta","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/10\/SM.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/10\/SM.png","caption":"Shitij Mehta"},"description":"Shitij is the product owner for ModelBuilder in ArcGIS Desktop and leads ModelBuilder efforts in web environments at Esri. She oversees the full product lifecycle\u2014from feature design and development to testing and refinement\u2014ensuring a seamless experience for users. Beyond the office, Shitij is a Heartfulness meditation trainer, dedicated volunteer, and passionate researcher focused on tigers and elephants.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/shitijmehta"}]}},"text_date":"July 5, 2012","author_name":"Shitij Mehta","author_page":"https:\/\/www.esri.com\/arcgis-blog\/author\/shitijmehta","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/08\/Newsroom-Keyart-Wide-1920-x-1080.jpg","primary_product":"ArcMap","tag_data":[{"term_id":24321,"name":"geoprocessing","slug":"geoprocessing","term_group":0,"term_taxonomy_id":24321,"taxonomy":"post_tag","description":"","parent":0,"count":131,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1333,"filter":"raw"}],"product_data":[{"term_id":36991,"name":"ArcMap","slug":"arcgis-desktop","term_group":0,"term_taxonomy_id":36991,"taxonomy":"product","description":"","parent":36981,"count":325,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-desktop","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/179091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/4041"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=179091"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/179091\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=179091"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=179091"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=179091"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=179091"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=179091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}