{"id":1697582,"date":"2022-08-29T08:50:55","date_gmt":"2022-08-29T15:50:55","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1697582"},"modified":"2022-09-21T22:23:11","modified_gmt":"2022-09-22T05:23:11","slug":"how-to-join-data-with-data-engineering","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering","title":{"rendered":"How to join data with Data Engineering"},"author":10232,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341],"tags":[24311,760452,34601,766452,176452],"industry":[],"product":[36561],"class_list":["post-1697582","blog","type-blog","status-publish","format-standard","hentry","category-analytics","tag-analysis","tag-data-engineering","tag-data-exploration","tag-data-preparation","tag-mapping","product-arcgis-pro"],"acf":{"short_description":"Learn how to use Data Engineering to explore and evaluate your joins.","flexible_content":[{"acf_fc_layout":"content","content":"<p>Joining layers or fields is a common and critical part of the data engineering process. But it can sometimes be challenging to investigate and evaluate the success of the join. With <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/analysis\/geoprocessing\/data-engineering\/what-is-data-engineering.htm\">Data Engineering in ArcGIS Pro<\/a>, this process can be much more effective and enjoyable.<\/p>\n<p>Data Engineering can help you quickly identify joined fields. If you have a large table, it helps you easily see where the joined fields begin, and how many fields were added. If you have multiple joined tables, it can help you easily identify the source of each joined field. This can make it easier for you to identify your fields of interest, then you can use Data Engineering to make a copy of that field. Check out the video to find out how.<\/p>\n"},{"acf_fc_layout":"kaltura","video_id":"1_b1yjxpyl","time":false,"start":0,"stop":""},{"acf_fc_layout":"content","content":"<p>&nbsp;<\/p>\n<p>Data Engineering can also help you find out if a join has been successful. The short video below shows you how to use the statistics panel to check for nulls in the joined fields. This can be a quicker and more accurate way to check the join than looking at the attribute table.<\/p>\n"},{"acf_fc_layout":"kaltura","video_id":"1_ojj3o9x4","time":false,"start":0,"stop":""},{"acf_fc_layout":"content","content":"<p>&nbsp;<\/p>\n<p>These videos have showcased how you can use Data Engineering to join fields using the <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/2.9\/tool-reference\/data-management\/add-join.htm\">Add Join<\/a> tool. However, ArcGIS Pro has a few other ways to join layers. The Integrate group of tools contains the <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/analysis\/spatial-join.htm\">Spatial Join<\/a> and <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/tool-reference\/data-management\/join-field.htm\">Join Field<\/a> tools. The Spatial Join tool enables you to join fields based on their spatial relationship to the input features. The Join Field tool lets you transfer one or more fields to the input table permanently. You can access these tools from the <a href=\"https:\/\/pro.arcgis.com\/en\/pro-app\/latest\/help\/analysis\/geoprocessing\/data-engineering\/prepare-your-data.htm#ESRI_SECTION1_1BD3FF20BED2403283C97FF50C02B293\">Data Engineering ribbon<\/a>, in the Tools groups and the Integrate menu, or by right clicking fields in the fields panel or rows in the statistics table.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":1697592,"id":1697592,"title":"Integrate Joins","filename":"Integrate-Joins.png","filesize":12418,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/Integrate-Joins.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering\/integrate-joins","alt":"Tools Integrate menu","author":"10232","description":"","caption":"","name":"integrate-joins","status":"inherit","uploaded_to":1697582,"date":"2022-08-25 19:07:16","modified":"2022-08-25 19:07:33","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":292,"height":378,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/Integrate-Joins-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/Integrate-Joins.png","medium-width":202,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/Integrate-Joins.png","medium_large-width":292,"medium_large-height":378,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/Integrate-Joins.png","large-width":292,"large-height":378,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/Integrate-Joins.png","1536x1536-width":292,"1536x1536-height":378,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/Integrate-Joins.png","2048x2048-width":292,"2048x2048-height":378,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/Integrate-Joins.png","card_image-width":292,"card_image-height":378,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/Integrate-Joins.png","wide_image-width":292,"wide_image-height":378}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p style=\"text-align: left\"><a href=\"https:\/\/learn.arcgis.com\/en\/paths\/data-engineering-in-arcgis-pro\/\">View more resources about how to use Data Engineering<\/a><\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/mediaspace.esri.com\/channel\/Data%2BEngineering\/266526862\">Watch all the Data Engineering: How to videos on our channel<\/a><\/p>\n"},{"acf_fc_layout":"sidebar","content":"<p><strong>Check out the other articles in our Data Engineering how to series:<\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-get-started-with-data-engineering\/\">How to get started<\/a><\/li>\n<li><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-explore-fields-with-data-engineering\/\">How to explore fields<\/a><\/li>\n<li><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-convert-field-types-with-data-engineering\/\">How to convert field types<\/a><\/li>\n<li><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering\/\">How to join data<\/a><\/li>\n<li><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-work-with-numeric-fields-in-data-engineering\/\">How to work with numeric data<\/a><\/li>\n<li><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-work-with-text-fields-in-data-engineering\/\">How to work with text data<\/a><\/li>\n<li><a href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/analytics\/analytics\/how-to-work-with-date-fields-in-data-engineering\/\">How to work with date data<\/a><\/li>\n<li>How to work with missing data (coming soon)<\/li>\n<\/ol>\n<p>\u2026and more to follow<\/p>\n","image_reference":false,"layout":"standard","image_reference_figure":"","snippet":"","spotlight_name":"","section_title":"","position":"Center","spotlight_image":false}],"authors":[{"ID":10232,"user_firstname":"Lynne","user_lastname":"Buie","nickname":"Lynne Buie","user_nicename":"lbuie","display_name":"Lynne Buie","user_email":"lbuie@esri.com","user_url":"http:\/\/esriurl.com\/spatialstats","user_registered":"2019-11-22 19:46:25","user_description":"Lynne Buie is a Product Engineer on the Spatial Statistics team. She helps build spatial statistics tools and Data Engineering capabilities for ArcGIS Pro. She's passionate about using GIS to help make the world a better place.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/02\/LynneBuie2024_600x600-465x465.jpeg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"},{"ID":7101,"user_firstname":"Alberto","user_lastname":"Nieto","nickname":"Alberto Nieto","user_nicename":"albe9057esri-com_esrifederal","display_name":"Alberto Nieto","user_email":"ANieto@esri.com","user_url":"https:\/\/esriurl.com\/spatialstats","user_registered":"2018-03-02 00:19:18","user_description":"Alberto Nieto is a Product Engineer on Esri\u2019s Spatial Statistics team. In his role, he helps research, build, and maintain spatial data science capabilities in ArcGIS and works closely with government agencies to learn about the problems our software can help solve. Alberto\u2019s background includes fourteen years of experience, including previous roles as a GIS Developer at Capital One and NOAA's Climate Prediction Center, and as a GIS Analyst at the Census Bureau and the Alachua County Environmental Protection Department.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2021\/04\/Alberto_Nieto-465x465.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"},{"ID":9862,"user_firstname":"Ankita","user_lastname":"Bakshi","nickname":"Ankita Bakshi","user_nicename":"abakshi","display_name":"Ankita Bakshi","user_email":"ABakshi@esri.com","user_url":"https:\/\/spatialstats.github.io\/","user_registered":"2019-08-13 18:45:44","user_description":"Ankita Bakshi is a Product Owner and a Senior Product Engineer on the Spatial Statistics Team at Esri. With a background in environmental engineering and computer science, she is passionate about solving social, economic, and environmental problems with Spatial Analysis and Data Science. In her role, Ankita enjoys researching, finding solutions to build software, and loves creating video and written content to make the software tools more approachable and applicable to real world challenges. Outside of work Ankita enjoys going on hikes and dancing to Bollywood music.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2019\/12\/Ankita_Bakshi-e1577730248180-259x261.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"}],"related_articles":[{"ID":1685432,"post_author":"7101","post_date":"2022-08-15 10:16:10","post_date_gmt":"2022-08-15 17:16:10","post_content":"","post_title":"How to get started with Data Engineering","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"how-to-get-started-with-data-engineering","to_ping":"","pinged":"","post_modified":"2022-09-21 22:21:42","post_modified_gmt":"2022-09-22 05:21:42","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1685432","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1685192,"post_author":"9862","post_date":"2022-08-15 11:16:03","post_date_gmt":"2022-08-15 18:16:03","post_content":"","post_title":"How to explore fields with Data Engineering","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"how-to-explore-fields-with-data-engineering","to_ping":"","pinged":"","post_modified":"2024-11-27 13:48:52","post_modified_gmt":"2024-11-27 21:48:52","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1685192","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1669162,"post_author":"10232","post_date":"2022-08-22 12:40:12","post_date_gmt":"2022-08-22 19:40:12","post_content":"","post_title":"How to convert field types with Data Engineering","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"how-to-convert-field-types-with-data-engineering","to_ping":"","pinged":"","post_modified":"2022-09-21 22:23:18","post_modified_gmt":"2022-09-22 05:23:18","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1669162","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"},{"ID":1235582,"post_author":"10232","post_date":"2021-05-20 09:38:34","post_date_gmt":"2021-05-20 16:38:34","post_content":"","post_title":"Introducing Data Engineering in ArcGIS Pro","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"introducing-data-engineering-in-arcgis-pro","to_ping":"","pinged":"","post_modified":"2022-03-30 15:09:05","post_modified_gmt":"2022-03-30 22:09:05","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1235582","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"1","filter":"raw"},{"ID":1186302,"post_author":"207622","post_date":"2021-04-07 09:09:30","post_date_gmt":"2021-04-07 16:09:30","post_content":"","post_title":"Dev Summit 2021: Data Engineering in ArcGIS Pro","post_excerpt":"","post_status":"publish","comment_status":"closed","ping_status":"closed","post_password":"","post_name":"data-engineering-in-arcgis-pro","to_ping":"","pinged":"","post_modified":"2021-08-20 15:19:13","post_modified_gmt":"2021-08-20 22:19:13","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1186302","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}],"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/DE_card_826x465_v3.png","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/DE_banner_1920x1080_v6.png"},"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>How to join data with Data Engineering<\/title>\n<meta name=\"description\" content=\"Learn how to use Data Engineering to explore and evaluate your joins.\" \/>\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-pro\/analytics\/how-to-join-data-with-data-engineering\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to join data with Data Engineering\" \/>\n<meta property=\"og:description\" content=\"Learn how to use Data Engineering to explore and evaluate your joins.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering\" \/>\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=\"2022-09-22T05:23:11+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-pro\/analytics\/how-to-join-data-with-data-engineering#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering\"},\"author\":{\"name\":\"Lynne Buie\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/bced076cb0fabe0f0ad2b04296ab4ce5\"},\"headline\":\"How to join data with Data Engineering\",\"datePublished\":\"2022-08-29T15:50:55+00:00\",\"dateModified\":\"2022-09-22T05:23:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering\"},\"wordCount\":7,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"Analysis\",\"Data Engineering\",\"data exploration\",\"data preparation\",\"mapping\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering\",\"name\":\"How to join data with Data Engineering\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2022-08-29T15:50:55+00:00\",\"dateModified\":\"2022-09-22T05:23:11+00:00\",\"description\":\"Learn how to use Data Engineering to explore and evaluate your joins.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to join data with Data Engineering\"}]},{\"@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\/bced076cb0fabe0f0ad2b04296ab4ce5\",\"name\":\"Lynne Buie\",\"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\/2024\/02\/LynneBuie2024_600x600-465x465.jpeg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/02\/LynneBuie2024_600x600-465x465.jpeg\",\"caption\":\"Lynne Buie\"},\"description\":\"Lynne Buie is a Product Engineer on the Spatial Statistics team. She helps build spatial statistics tools and Data Engineering capabilities for ArcGIS Pro. She's passionate about using GIS to help make the world a better place.\",\"sameAs\":[\"http:\/\/esriurl.com\/spatialstats\"],\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/lbuie\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to join data with Data Engineering","description":"Learn how to use Data Engineering to explore and evaluate your joins.","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-pro\/analytics\/how-to-join-data-with-data-engineering","og_locale":"en_US","og_type":"article","og_title":"How to join data with Data Engineering","og_description":"Learn how to use Data Engineering to explore and evaluate your joins.","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2022-09-22T05:23:11+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-pro\/analytics\/how-to-join-data-with-data-engineering#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering"},"author":{"name":"Lynne Buie","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/bced076cb0fabe0f0ad2b04296ab4ce5"},"headline":"How to join data with Data Engineering","datePublished":"2022-08-29T15:50:55+00:00","dateModified":"2022-09-22T05:23:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering"},"wordCount":7,"commentCount":0,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["Analysis","Data Engineering","data exploration","data preparation","mapping"],"articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering","name":"How to join data with Data Engineering","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2022-08-29T15:50:55+00:00","dateModified":"2022-09-22T05:23:11+00:00","description":"Learn how to use Data Engineering to explore and evaluate your joins.","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"How to join data with Data Engineering"}]},{"@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\/bced076cb0fabe0f0ad2b04296ab4ce5","name":"Lynne Buie","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\/2024\/02\/LynneBuie2024_600x600-465x465.jpeg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2024\/02\/LynneBuie2024_600x600-465x465.jpeg","caption":"Lynne Buie"},"description":"Lynne Buie is a Product Engineer on the Spatial Statistics team. She helps build spatial statistics tools and Data Engineering capabilities for ArcGIS Pro. She's passionate about using GIS to help make the world a better place.","sameAs":["http:\/\/esriurl.com\/spatialstats"],"url":"https:\/\/www.esri.com\/arcgis-blog\/author\/lbuie"}]}},"text_date":"August 29, 2022","author_name":"Multiple Authors","author_page":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/analytics\/how-to-join-data-with-data-engineering","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/08\/DE_banner_1920x1080_v6.png","primary_product":"ArcGIS Pro","tag_data":[{"term_id":24311,"name":"Analysis","slug":"analysis","term_group":0,"term_taxonomy_id":24311,"taxonomy":"post_tag","description":"","parent":0,"count":96,"filter":"raw"},{"term_id":760452,"name":"Data Engineering","slug":"data-engineering","term_group":0,"term_taxonomy_id":760452,"taxonomy":"post_tag","description":"","parent":0,"count":34,"filter":"raw"},{"term_id":34601,"name":"data exploration","slug":"data-exploration","term_group":0,"term_taxonomy_id":34601,"taxonomy":"post_tag","description":"","parent":0,"count":14,"filter":"raw"},{"term_id":766452,"name":"data preparation","slug":"data-preparation","term_group":0,"term_taxonomy_id":766452,"taxonomy":"post_tag","description":"","parent":0,"count":6,"filter":"raw"},{"term_id":176452,"name":"mapping","slug":"mapping","term_group":0,"term_taxonomy_id":176452,"taxonomy":"post_tag","description":"","parent":0,"count":60,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1328,"filter":"raw"}],"product_data":[{"term_id":36561,"name":"ArcGIS Pro","slug":"arcgis-pro","term_group":0,"term_taxonomy_id":36561,"taxonomy":"product","description":"","parent":0,"count":2036,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-pro","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1697582","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\/10232"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=1697582"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/1697582\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=1697582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=1697582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=1697582"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=1697582"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=1697582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}