{"id":182580,"date":"2024-03-28T03:15:00","date_gmt":"2024-03-28T02:15:00","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=182580"},"modified":"2024-11-27T14:23:55","modified_gmt":"2024-11-27T13:23:55","slug":"how-do-i-merge-tables-in-power-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query","title":{"rendered":"How do I merge tables in Power Query?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"182580\" class=\"elementor elementor-182580\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2b01ef3 e-flex e-con-boxed e-con\" data-id=\"2b01ef3\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d473da9 elementor-widget elementor-widget-heading\" data-id=\"d473da9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Confronted with numerous sources of data, data experts need to identify the relationships between different pieces of information. To do this, they can merge two tables with Power Query. This query editor simplifies the task of data modeling, for more efficient and reliable analysis.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-85723c9 e-flex e-con-boxed e-con\" data-id=\"85723c9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-98bdbe7 elementor-widget elementor-widget-heading\" data-id=\"98bdbe7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is the merge function in Power Query?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-de6c7d6 elementor-widget elementor-widget-text-editor\" data-id=\"de6c7d6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Merging tables in Power Query allows you to join two queries found in Excel, or an Excel query and a query from an external <a href=\"https:\/\/datascientest.com\/en\/data-sources-understanding-the-definition-and-inner-workings\">data source<\/a> (such as Power BI).<\/p><p>You can choose between two types of merge:<\/p><ol><li><strong>Embedded merge:<\/strong> data is integrated into an existing query.<\/li><li><strong>Intermediate merge:<\/strong> a new query is created for each merge operation.<\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-14fba0a elementor-widget elementor-widget-text-editor\" data-id=\"14fba0a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>For example, this type of grouping can be useful for companies with several subsidiaries. In this case, each subsidiary often has its own table representing sales. If you want a consolidated view of all group transactions, you can use <strong>Power Query<\/strong> to merge the subsidiary tables.<\/p><p><strong>Good to know:<\/strong> you can only merge two queries for which you have the necessary access rights. <a href=\"https:\/\/datascientest.com\/en\/power-query-what-is-it-whats-it-for\">Power Query<\/a>&#8216;s different levels of confidentiality (public, organizational and private) prevent you from accidentally merging tables containing<a href=\"https:\/\/datascientest.com\/en\/records-manager-a-key-data-governance-job\"> sensitive data.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f3e2ced elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"f3e2ced\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn to use Power Query<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-16924f9 e-flex e-con-boxed e-con\" data-id=\"16924f9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-99334bd elementor-widget elementor-widget-heading\" data-id=\"99334bd\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I merge 2 tables with Power Query?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-01dd985 elementor-widget elementor-widget-heading\" data-id=\"01dd985\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Merging 2 tables with the Power Query editor<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aec21c6 elementor-widget elementor-widget-text-editor\" data-id=\"aec21c6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>If you have 2 tables to group, with at least one or more columns to combine, you can use <strong>Power Query<\/strong> to merge the 2 tables. Here&#8217;s how to do it:<\/p><ul><li>Start by opening a query in the Power Query editor.<\/li><li>Choose a cell and select &#8220;Query&#8221;, then &#8220;Modify&#8221;.<\/li><li>In &#8220;Home&#8221;, click on &#8220;Merge queries&#8221;. By default, this is an embedded merge. If you require an intermediate merge, click on &#8220;Merge queries as New&#8221;.<\/li><li>In the dialog box, select the main table first, then a join column (simply click on the column header).<\/li><li>Next, select the associated secondary table, then the corresponding column. You will then see the number of matches.<\/li><li>This will tell you whether or not there are any errors in the merge operation.<\/li><li>Select the type of join.<\/li><li>Click on &#8220;Use approximate match to perform the merge&#8221;, then choose from the various approximate match options. This step is optional.<\/li><li>Click on &#8220;Include matching lines only&#8221;.<\/li><li>Otherwise, you&#8217;ll get a left outer join.<\/li><li>Click on OK.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9cbaf46 elementor-widget elementor-widget-image\" data-id=\"9cbaf46\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-2-tables-power-query1.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c742cfe elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"c742cfe\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Mastering Power Query<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-19cc068 elementor-widget elementor-widget-heading\" data-id=\"19cc068\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">The different types of join<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5981030 elementor-widget elementor-widget-text-editor\" data-id=\"5981030\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Power Query offers several types of joins in its table merge query. Here are your options:<\/p><ul><li>Internal join: this is the default option. In this case, only the rows corresponding to the primary and secondary tables will be integrated.<\/li><li>Left outer join: all rows of the primary table are maintained, plus the corresponding rows of the secondary table.<\/li><li>Right outer join: conversely, all rows from the secondary table are maintained, along with the corresponding rows from the primary table.<\/li><li>Full outer: rows from two tables are inserted in their entirety.<\/li><li>Left anti-join: only rows from the primary table that have no correspondence with the secondary table are joined.<\/li><li>Right anti-join: only rows from the secondary table that do not match the primary table are combined.<\/li><li>Cross-join: combines all rows in the primary table with those in the secondary table.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0f879e9 elementor-widget elementor-widget-heading\" data-id=\"0f879e9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Bonus tips<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d36c3f0 elementor-widget elementor-widget-text-editor\" data-id=\"d36c3f0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Tip no. 1:<\/strong> To successfully merge 2 tables with Power Query, you must have the same number of columns to match, and above all, select them in the right order.<\/p><p>For example, if, for the main table, you select a unit price column first, a product column second and a quantity column third, you must respect exactly the same order for the secondary table. It is this selection order that will enable the comparison of common columns.<\/p><p>Similarly, linked columns must have the same format. For example, the 2 price columns must contain numbers, while the two product columns contain textual data.<\/p><p><strong>Tip 2:<\/strong> To better understand the relationships between the two merged tables, you can use the &#8220;Query dependencies&#8221; dialog box. To do this, follow the steps below:<\/p><ul><li>Click on &#8220;Show dependencies&#8221;.<\/li><li>Click on &#8220;Query&#8221;.<\/li><li>Select the &#8220;Layout&#8221; command (this will allow you to control the orientation of the visual representation).<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-642498d e-flex e-con-boxed e-con\" data-id=\"642498d\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a8e6426 elementor-widget elementor-widget-heading\" data-id=\"a8e6426\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Join DataScientest to manage your databases<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fa53491 elementor-widget elementor-widget-text-editor\" data-id=\"fa53491\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Thanks to its wide range of queries, the Power Query editor is one of the preferred tools of data experts for managing and modeling their databases. But mastering all the available queries requires both theoretical and practical <strong>Power Query training.<\/strong><\/p><p>This is exactly what we offer at DataScientest. Once you&#8217;ve familiarized yourself with the main concepts, you&#8217;ll be able to apply them to real-life situations. You&#8217;ll be up and running by the end of the course. Come and join us!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cf631f3 elementor-widget elementor-widget-image\" data-id=\"cf631f3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-2-tables-power-query2.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c3fed1e elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"c3fed1e\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn all about Power Query<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4273dfb e-flex e-con-boxed e-con\" data-id=\"4273dfb\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-20252d6 elementor-widget elementor-widget-html\" data-id=\"20252d6\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"How do I merge 2 tables with Power Query?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"If you have 2 tables to merge, with at least one or more columns to combine, you can use Power Query to merge the 2 tables. Start by opening a query in the Power Query editor. Choose a cell and select \"Query\", then \"Modify\". In \"Home\", click on \"Merge queries\". By default, this is an embedded merge. If you want an intermediate merge, click on \"Merge queries as New\".\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Join DataScientest to manage your databases\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Thanks to its multiple queries, the Power Query editor is one of the preferred tools of data experts for managing and modeling their databases. But mastering all the available queries requires both theoretical and practical Power Query training. This is exactly what we offer at DataScientest. Once you've familiarized yourself with the main concepts, you'll be able to apply them to real-life situations. You'll be up and running by the end of the course. Join us!\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What is the merge functionality in Power Query?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The table merge feature in Power Query allows you to join two Excel queries, or an Excel query and a query from an external data source (such as Power BI). You can choose between two types of merge: Embedded merge: the data is integrated into an existing query. Intermediate merge: a new query is created for each merge operation.\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Confronted with numerous sources of data, data experts need to identify the relationships between different pieces of information. To do this, they can merge two tables with Power Query. This query editor simplifies the task of data modeling, for more efficient and reliable analysis. What is the merge function in Power Query? Merging tables in [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":182581,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How do I merge tables in Power Query?<\/title>\n<meta name=\"description\" content=\"If you want to merge tables in Power Query, the first step, according to the best practices, is to make sure...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do I merge tables in Power Query?\" \/>\n<meta property=\"og:description\" content=\"Confronted with numerous sources of data, data experts need to identify the relationships between different pieces of information. To do this, they can\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-28T02:15:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-27T13:23:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/03\/fusion-2-tables-power-query-768x384-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"384\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"How do I merge tables in Power Query?\",\"datePublished\":\"2024-03-28T02:15:00+00:00\",\"dateModified\":\"2024-11-27T13:23:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query\"},\"wordCount\":774,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query\",\"url\":\"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query\",\"name\":\"How do I merge tables in Power Query?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-03-28T02:15:00+00:00\",\"dateModified\":\"2024-11-27T13:23:55+00:00\",\"description\":\"If you want to merge tables in Power Query, the first step, according to the best practices, is to make sure...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How do I merge tables in Power Query?","description":"If you want to merge tables in Power Query, the first step, according to the best practices, is to make sure...","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:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query","og_locale":"en_GB","og_type":"article","og_title":"How do I merge tables in Power Query?","og_description":"Confronted with numerous sources of data, data experts need to identify the relationships between different pieces of information. To do this, they can","og_url":"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-03-28T02:15:00+00:00","article_modified_time":"2024-11-27T13:23:55+00:00","og_image":[{"width":768,"height":384,"url":"https:\/\/datascientest.com\/en\/files\/2024\/03\/fusion-2-tables-power-query-768x384-1.jpg","type":"image\/jpeg"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"How do I merge tables in Power Query?","datePublished":"2024-03-28T02:15:00+00:00","dateModified":"2024-11-27T13:23:55+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query"},"wordCount":774,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query","url":"https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query","name":"How do I merge tables in Power Query?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-03-28T02:15:00+00:00","dateModified":"2024-11-27T13:23:55+00:00","description":"If you want to merge tables in Power Query, the first step, according to the best practices, is to make sure...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/how-do-i-merge-tables-in-power-query"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/182580"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=182580"}],"version-history":[{"count":3,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/182580\/revisions"}],"predecessor-version":[{"id":192224,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/182580\/revisions\/192224"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/182581"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=182580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=182580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=182580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}