{"id":3706,"date":"2023-07-16T00:52:31","date_gmt":"2023-07-16T00:52:31","guid":{"rendered":"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/"},"modified":"2023-07-16T00:52:31","modified_gmt":"2023-07-16T00:52:31","slug":"lampirkan-permintaan-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/","title":{"rendered":"Kueri google spreadsheet: cara menggabungkan dua tabel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menggunakan fungsi <strong>QUERY()<\/strong> di Google Spreadsheet untuk menggabungkan dua tabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sayangnya, fungsi <strong>JOIN()<\/strong> tidak ada dalam fungsi <strong>QUERY()<\/strong> , namun Anda bisa menggunakan rumus berikut sebagai solusi untuk menggabungkan dua tabel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" string \" dir=\"auto\">=ArrayFormula(\n   {\n     <span style=\"color: #ff6600;\">A2:B6<\/span> ,\n     vlookup( <span style=\"color: #800080;\">A2:A6<\/span> , <span style=\"color: #3366ff;\">D2:E6<\/span> ,COLUMN(Indirect(\" <span style=\"color: #008000;\">R1C2:R1C<\/span> \"&amp;COLUMNS( <span style=\"color: #3366ff;\">D2:E6<\/span> ),0)),0)\n   }\n)\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini melakukan penggabungan kiri pada tabel yang terletak di rentang <strong>A2:B6<\/strong> dan <strong>D2:E6<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menggabungkan dua tabel di Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki dua tabel berikut di Google Spreadsheet yang berisi informasi tentang berbagai tim bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30264 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuillesjoindre1.jpg\" alt=\"\" width=\"546\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk melakukan penggabungan kiri pada kedua tabel dan mengembalikan tabel yang berisi nama tim, poin, dan assist untuk setiap tim di tabel kiri:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" string \" dir=\"auto\">=ArrayFormula(\n   {\n     <span style=\"color: #ff6600;\">A2:B6<\/span> ,\n     vlookup( <span style=\"color: #800080;\">A2:A6<\/span> , <span style=\"color: #3366ff;\">D2:E6<\/span> ,COLUMN(Indirect(\" <span style=\"color: #008000;\">R1C2:R1C<\/span> \"&amp;COLUMNS( <span style=\"color: #3366ff;\">D2:E6<\/span> ),0)),0)\n   }\n)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan rumus ini dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30265\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuillesjoindre2.jpg\" alt=\"Bergabunglah dengan kueri Google Spreadsheet\" width=\"631\" height=\"528\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hasilnya adalah tabel yang berisi nama tim, poin dan assist untuk masing-masing tim pada tabel di sebelah kiri.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika tim di tabel kiri tidak ada di tabel kanan, nilai <strong>#N\/A<\/strong> akan dikembalikan di kolom Assist pada tabel yang dihasilkan.<\/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 Google Spreadsheet.<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara Membuat Kueri dari Sheet Lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/berisi-kueri-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: pilih baris yang berisi string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/\">Kueri Google Spreadsheet: Cara Menggunakan Grup Berdasarkan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menggunakan fungsi QUERY() di Google Spreadsheet untuk menggabungkan dua tabel. Sayangnya, fungsi JOIN() tidak ada dalam fungsi QUERY() , namun Anda bisa menggunakan rumus berikut sebagai solusi untuk menggabungkan dua tabel: =ArrayFormula( { A2:B6 , vlookup( A2:A6 , D2:E6 ,COLUMN(Indirect(&#8221; R1C2:R1C &#8220;&amp;COLUMNS( D2:E6 ),0)),0) } ) Rumus khusus ini melakukan penggabungan [&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>Kueri Google Spreadsheet: Cara Menggabungkan Dua Tabel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan dua tabel di Google Sheets, dengan contoh langkah demi langkah.\" \/>\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\/lampirkan-permintaan-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kueri Google Spreadsheet: Cara Menggabungkan Dua Tabel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan dua tabel di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T00:52:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuillesjoindre1.jpg\" \/>\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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/\",\"name\":\"Kueri Google Spreadsheet: Cara Menggabungkan Dua Tabel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T00:52:31+00:00\",\"dateModified\":\"2023-07-16T00:52:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan dua tabel di Google Sheets, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara menggabungkan dua tabel\"}]},{\"@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":"Kueri Google Spreadsheet: Cara Menggabungkan Dua Tabel - Statologi","description":"Tutorial ini menjelaskan cara menggabungkan dua tabel di Google Sheets, dengan contoh langkah demi langkah.","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\/lampirkan-permintaan-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara Menggabungkan Dua Tabel - Statologi","og_description":"Tutorial ini menjelaskan cara menggabungkan dua tabel di Google Sheets, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-16T00:52:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/feuillesjoindre1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/","url":"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/","name":"Kueri Google Spreadsheet: Cara Menggabungkan Dua Tabel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T00:52:31+00:00","dateModified":"2023-07-16T00:52:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan dua tabel di Google Sheets, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lampirkan-permintaan-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara menggabungkan dua tabel"}]},{"@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\/3706"}],"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=3706"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3706\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}