{"id":4509,"date":"2023-07-10T12:51:06","date_gmt":"2023-07-10T12:51:06","guid":{"rendered":"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/"},"modified":"2023-07-10T12:51:06","modified_gmt":"2023-07-10T12:51:06","slug":"gabungan-dalam-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/","title":{"rendered":"Cara melakukan inner join di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>Gabungan dalam<\/strong> memungkinkan Anda menggabungkan dua tabel yang satu-satunya baris dalam tabel yang dihasilkan adalah baris dengan nilai yang cocok dalam kolom yang sama untuk kedua tabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut ini memperlihatkan cara menggunakan fungsionalitas <b>Power Query<\/b> di Excel untuk melakukan penggabungan dalam pada dua tabel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan nilai untuk setiap tabel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan nilai berikut untuk dua tabel di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35239 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij1.png\" alt=\"\" width=\"491\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita akan melakukan inner join dimana kita hanya akan menyimpan baris dari setiap tabel yang memiliki nilai yang cocok pada kolom <strong>Team<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Ubah Setiap Rentang menjadi Tabel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita perlu mengubah setiap rentang nilai menjadi array.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, sorot rentang sel <strong>A1:B8<\/strong> , lalu klik tab Sisipkan di sepanjang pita atas, lalu klik ikon <strong>Tabel<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35240 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij2.png\" alt=\"\" width=\"488\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik tombol <strong>OK<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ulangi langkah-langkah ini untuk rentang sel <strong>D1:E6<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kedua rentang data kini akan muncul dalam bentuk tabel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35241 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij3.png\" alt=\"\" width=\"501\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Gunakan Power Query untuk melakukan penggabungan dalam<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan sel mana pun di tabel pertama, dan klik <b>Dapatkan Data Tabel\/Rentang<\/b> dari menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35242 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij4.png\" alt=\"\" width=\"403\" height=\"531\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel akan dimuat ke dalam editor Power Query.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, cukup klik ikon <strong>Close and Load<\/strong> di pojok kiri atas, lalu klik <strong>Close and Load To<\/strong> dari menu drop-down:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35243 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij5.png\" alt=\"\" width=\"578\" height=\"417\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Pada jendela baru yang muncul, pilih <strong>Create connection only<\/strong> lalu klik <strong>OK<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35244 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij6.png\" alt=\"\" width=\"313\" height=\"325\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan sel mana pun di tabel kedua, dan klik <b>Dapatkan Data Tabel\/Rentang<\/b> dari menu drop-down:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tabel kedua akan dimuat ke dalam editor Power Query.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik ikon <strong>Gabungkan Kueri<\/strong> di grup <strong>Gabungkan<\/strong> di sepanjang pita atas Editor Power Query.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, tempatkan <strong>Tabel1<\/strong> pada kotak pertama dan <strong>Tabel2<\/strong> pada kotak kedua. Kemudian klik kolom <strong>tim<\/strong> pada masing-masing tabel. Lalu klik <strong>Inner<\/strong> di menu drop-down <strong>Join Kind<\/strong> , dan klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-35245\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij7.png\" alt=\"gabung dalam di Excel\" width=\"649\" height=\"580\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , penggabungan dalam akan dilakukan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35246 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij8.png\" alt=\"\" width=\"578\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik ikon panah kiri dan kanan pada kolom berlabel <strong>Tabel2<\/strong> , lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35247 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij9.png\" alt=\"\" width=\"453\" height=\"355\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kolom <strong>rebound<\/strong> pada tabel kedua akan muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35248 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij10.png\" alt=\"\" width=\"535\" height=\"187\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, klik lagi ikon <strong>Close and Load To<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, klik <strong>Tabel<\/strong> dan <strong>Lembar Kerja Baru<\/strong> , lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35249 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij11.png\" alt=\"\" width=\"358\" height=\"367\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel akhir yang dihasilkan dari gabungan dalam sekarang akan ditampilkan di lembar kerja baru:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35250 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij12.png\" alt=\"\" width=\"430\" height=\"378\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya baris berisi nama tim yang muncul di kedua tabel yang ada di tabel final.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/kiri-bergabung-di-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara melakukan gabung kiri di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pencocokan-fuzzy-di-excel\/\" target=\"_blank\" rel=\"noopener\">Bagaimana melakukan pencocokan fuzzy di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-vlookup-dari-buku-kerja-lain\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan VLOOKUP dari buku kerja lain di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gabungan dalam memungkinkan Anda menggabungkan dua tabel yang satu-satunya baris dalam tabel yang dihasilkan adalah baris dengan nilai yang cocok dalam kolom yang sama untuk kedua tabel. Contoh langkah demi langkah berikut ini memperlihatkan cara menggunakan fungsionalitas Power Query di Excel untuk melakukan penggabungan dalam pada dua tabel. Langkah 1: Masukkan nilai untuk setiap tabel [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Melakukan Inner Join di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan inner join di Excel, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Inner Join di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan inner join di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T12:51:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/\",\"name\":\"Cara Melakukan Inner Join di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T12:51:06+00:00\",\"dateModified\":\"2023-07-10T12:51:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan inner join di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan inner join di excel (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Melakukan Inner Join di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara melakukan inner join di Excel, dengan sebuah contoh.","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:\/\/statorials.org\/id\/gabungan-dalam-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Inner Join di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara melakukan inner join di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-10T12:51:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ij1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/","url":"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/","name":"Cara Melakukan Inner Join di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T12:51:06+00:00","dateModified":"2023-07-10T12:51:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan inner join di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/gabungan-dalam-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/gabungan-dalam-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan inner join di excel (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4509"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4509"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4509\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}