{"id":168651,"date":"2010-06-24T20:18:55","date_gmt":"2010-06-24T20:18:55","guid":{"rendered":"http:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=168651"},"modified":"2018-12-18T11:41:33","modified_gmt":"2018-12-18T19:41:33","slug":"validate-join-new-for-arcgis-10","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10","title":{"rendered":"Validate Join \u2013 New for ArcGIS 10"},"author":3601,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[37101,23851],"tags":[25311,25591,70121,28811],"industry":[],"product":[36991],"class_list":["post-168651","blog","type-blog","status-publish","format-standard","hentry","category-announcements","category-data-management","tag-arcgis-10","tag-arcgis-desktop","tag-spatial-join","tag-table","product-arcgis-desktop"],"acf":{"short_description":"New\u00a0for ArcGIS 10, you can analyze a join before creating it by using the Validate Join button on the Join Data dialog box. ","flexible_content":[{"acf_fc_layout":"content","content":"<p>New\u00a0for ArcGIS 10, you can analyze a join before creating it by using the Validate Join button on the Join Data dialog box. Join validation allows you to assess any potential problems that you might encounter when creating a join. Join validation analyzes the two participating datasets to determine if there are any common problems with the data. The following is a list of what is checked in the data:<\/p>\n<ul>\n<li>Check for field names that start with an invalid character.<\/li>\n<li>Check for field names that contain an invalid character.<\/li>\n<li>Check for field names that match reserved words.<\/li>\n<li>Check for non-geodatabase MS Access tables<\/li>\n<\/ul>\n<p><a href=\"http:\/\/downloads2.esri.com\/blogs\/images\/dev_14513.jpg\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"http:\/\/downloads2.esri.com\/blogs\/images\/dev_14513.jpg\" border=\"0\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n"}],"authors":[{"ID":3601,"user_firstname":"Rob","user_lastname":"Elkins","nickname":"rpe2","user_nicename":"rpe2","display_name":"Rob Elkins","user_email":"relkins@esri.com","user_url":"","user_registered":"2018-03-02 00:15:15","user_description":"","user_avatar":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/372025ad723ca3ed9f19047a9f7e1db155d632dbd4c919d556c8daa4654f15fa?s=96&#038;d=blank&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/372025ad723ca3ed9f19047a9f7e1db155d632dbd4c919d556c8daa4654f15fa?s=192&#038;d=blank&#038;r=g 2x' class='avatar avatar-96 photo' height='96' width='96' loading='lazy' decoding='async'\/>"}],"related_articles":"","card_image":false,"wide_image":false},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Validate Join \u2013 New for ArcGIS 10<\/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\/data-management\/validate-join-new-for-arcgis-10\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Validate Join \u2013 New for ArcGIS 10\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10\" \/>\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:41:33+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\/data-management\/validate-join-new-for-arcgis-10#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10\"},\"author\":{\"name\":\"Rob Elkins\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/3334a2f9ab0a4c95d2e01e7e7f44c5d5\"},\"headline\":\"Validate Join \u2013 New for ArcGIS 10\",\"datePublished\":\"2010-06-24T20:18:55+00:00\",\"dateModified\":\"2018-12-18T19:41:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10\"},\"wordCount\":5,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"ArcGIS 10\",\"ArcGIS Desktop\",\"spatial join\",\"table\"],\"articleSection\":[\"Announcements\",\"Data Management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10\",\"name\":\"Validate Join \u2013 New for ArcGIS 10\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2010-06-24T20:18:55+00:00\",\"dateModified\":\"2018-12-18T19:41:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Validate Join \u2013 New for ArcGIS 10\"}]},{\"@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\/3334a2f9ab0a4c95d2e01e7e7f44c5d5\",\"name\":\"Rob Elkins\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/372025ad723ca3ed9f19047a9f7e1db155d632dbd4c919d556c8daa4654f15fa?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/372025ad723ca3ed9f19047a9f7e1db155d632dbd4c919d556c8daa4654f15fa?s=96&d=blank&r=g\",\"caption\":\"Rob Elkins\"},\"url\":\"\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Validate Join \u2013 New for ArcGIS 10","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\/data-management\/validate-join-new-for-arcgis-10","og_locale":"en_US","og_type":"article","og_title":"Validate Join \u2013 New for ArcGIS 10","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2018-12-18T19:41:33+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\/data-management\/validate-join-new-for-arcgis-10#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10"},"author":{"name":"Rob Elkins","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/3334a2f9ab0a4c95d2e01e7e7f44c5d5"},"headline":"Validate Join \u2013 New for ArcGIS 10","datePublished":"2010-06-24T20:18:55+00:00","dateModified":"2018-12-18T19:41:33+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10"},"wordCount":5,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["ArcGIS 10","ArcGIS Desktop","spatial join","table"],"articleSection":["Announcements","Data Management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10","name":"Validate Join \u2013 New for ArcGIS 10","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2010-06-24T20:18:55+00:00","dateModified":"2018-12-18T19:41:33+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-desktop\/data-management\/validate-join-new-for-arcgis-10#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Validate Join \u2013 New for ArcGIS 10"}]},{"@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\/3334a2f9ab0a4c95d2e01e7e7f44c5d5","name":"Rob Elkins","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/372025ad723ca3ed9f19047a9f7e1db155d632dbd4c919d556c8daa4654f15fa?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/372025ad723ca3ed9f19047a9f7e1db155d632dbd4c919d556c8daa4654f15fa?s=96&d=blank&r=g","caption":"Rob Elkins"},"url":""}]}},"text_date":"June 24, 2010","author_name":"Rob Elkins","author_page":false,"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":25311,"name":"ArcGIS 10","slug":"arcgis-10","term_group":0,"term_taxonomy_id":25311,"taxonomy":"post_tag","description":"","parent":0,"count":48,"filter":"raw"},{"term_id":25591,"name":"ArcGIS Desktop","slug":"arcgis-desktop","term_group":0,"term_taxonomy_id":25591,"taxonomy":"post_tag","description":"","parent":0,"count":98,"filter":"raw"},{"term_id":70121,"name":"spatial join","slug":"spatial-join","term_group":0,"term_taxonomy_id":70121,"taxonomy":"post_tag","description":"","parent":0,"count":5,"filter":"raw"},{"term_id":28811,"name":"table","slug":"table","term_group":0,"term_taxonomy_id":28811,"taxonomy":"post_tag","description":"","parent":0,"count":7,"filter":"raw"}],"category_data":[{"term_id":37101,"name":"Announcements","slug":"announcements","term_group":0,"term_taxonomy_id":37101,"taxonomy":"category","description":"","parent":0,"count":1976,"filter":"raw"},{"term_id":23851,"name":"Data Management","slug":"data-management","term_group":0,"term_taxonomy_id":23851,"taxonomy":"category","description":"","parent":0,"count":926,"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\/168651","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\/3601"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=168651"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/168651\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=168651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=168651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=168651"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=168651"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=168651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}