{"id":2153,"date":"2023-07-23T11:39:55","date_gmt":"2023-07-23T11:39:55","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/"},"modified":"2023-07-23T11:39:55","modified_gmt":"2023-07-23T11:39:55","slug":"google-sheet-menanyakan-beberapa-lembar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/","title":{"rendered":"Google spreadsheet: cara menanyakan beberapa lembar"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menanyakan beberapa lembar di Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=QUERY({ <span style=\"color: #ff6600;\">Sheet1!A1:C9<\/span> ; <span style=\"color: #800080;\">Sheet2!A1:C9<\/span> ; <span style=\"color: #800080;\"><span style=\"color: #008080;\">Sheet3!A1:C9<\/span> <span style=\"color: #000000;\">}<\/span><\/span> <span style=\"color: #000000;\">)\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Anda juga dapat menggunakan sintaks berikut untuk memilih kolom tertentu di lembar:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=QUERY({ <span style=\"color: #ff6600;\">Sheet1!A1:C9<\/span> ; <span style=\"color: #800080;\">Sheet2!A1:C9<\/span> ; <span style=\"color: #800080;\"><span style=\"color: #008080;\">Sheet3!A1:C9<\/span> <span style=\"color: #000000;\">}, \" <span style=\"color: #008000;\">select Col1, Col2<\/span> \"<\/span><\/span> <span style=\"color: #000000;\">)<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Kueri dari beberapa lembar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki dua lembar berikut yang disebut Minggu1 dan Minggu2 yang berisi data pemain bola basket selama dua minggu berbeda:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19938 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multi1.png\" alt=\"\" width=\"469\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19939 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multi2.png\" alt=\"\" width=\"470\" height=\"347\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menanyakan data dari kedua sheet dan menempatkan hasilnya di sheet baru bernama <strong>All_Data<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=QUERY({ <span style=\"color: #ff6600;\">Week1!A1:C9<\/span> ; <span style=\"color: #800080;\">Week2!A1:C9<\/span> <span style=\"color: #800080;\"><span style=\"color: #000000;\">}<\/span><\/span> <span style=\"color: #000000;\">)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menggunakan rumus tersebut dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19940 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multi3.png\" alt=\"\" width=\"476\" height=\"428\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa semua data dari <strong>Minggu2<\/strong> ditumpuk di bawah data dari <strong>Minggu1<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Kueri dan pilih kolom dari beberapa lembar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita bisa menggunakan rumus berikut untuk menanyakan data dari kedua sheet dan menempatkan hasilnya di sheet baru bernama <strong>All_Data<\/strong> dan juga memilih hanya kolom tertentu untuk ditampilkan di sheet baru:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>=QUERY({ <span style=\"color: #ff6600;\">Week1!A1:C9<\/span> ; <span style=\"color: #800080;\">Week2!A1:C9<\/span> <span style=\"color: #800080;\"><span style=\"color: #000000;\">}, \" <span style=\"color: #008000;\">select Col1, Col2<\/span> \"<\/span><\/span> <span style=\"color: #000000;\">)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menggunakan rumus tersebut dalam praktik:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-19941 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multi4.png\" alt=\"\" width=\"476\" height=\"426\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya dua kolom pertama (&#8220;Tim&#8221; dan &#8220;Poin&#8221;) yang ditampilkan di lembar terakhir karena kami secara khusus memilih Col1 dan Col2 dalam pernyataan pemilihan kami.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan kueri umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kueri-google-sheet-pilih-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara memilih beberapa kolom dalam kueri<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara melakukan kueri dari sheet lain<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/grup-kueri-google-sheet-menurut\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara menggunakan Grup Berdasarkan dalam kueri<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/permintaan-kueri-google-sheets-diurutkan-berdasarkan\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara menggunakan Pesan Berdasarkan dalam kueri<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menanyakan beberapa lembar di Google Spreadsheet: =QUERY({ Sheet1!A1:C9 ; Sheet2!A1:C9 ; Sheet3!A1:C9 } ) Anda juga dapat menggunakan sintaks berikut untuk memilih kolom tertentu di lembar: =QUERY({ Sheet1!A1:C9 ; Sheet2!A1:C9 ; Sheet3!A1:C9 }, &#8221; select Col1, Col2 &#8221; ) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. [&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>Google Spreadsheet: Cara menanyakan beberapa lembar - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menanyakan beberapa lembar di Google Spreadsheet, dengan beberapa 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\/google-sheet-menanyakan-beberapa-lembar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara menanyakan beberapa lembar - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menanyakan beberapa lembar di Google Spreadsheet, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T11:39:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multi1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/\",\"name\":\"Google Spreadsheet: Cara menanyakan beberapa lembar - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T11:39:55+00:00\",\"dateModified\":\"2023-07-23T11:39:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menanyakan beberapa lembar di Google Spreadsheet, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara menanyakan beberapa lembar\"}]},{\"@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":"Google Spreadsheet: Cara menanyakan beberapa lembar - Statologi","description":"Tutorial ini menjelaskan cara menanyakan beberapa lembar di Google Spreadsheet, dengan beberapa 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\/google-sheet-menanyakan-beberapa-lembar\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara menanyakan beberapa lembar - Statologi","og_description":"Tutorial ini menjelaskan cara menanyakan beberapa lembar di Google Spreadsheet, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/","og_site_name":"Statorials","article_published_time":"2023-07-23T11:39:55+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/multi1.png"}],"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\/google-sheet-menanyakan-beberapa-lembar\/","url":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/","name":"Google Spreadsheet: Cara menanyakan beberapa lembar - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T11:39:55+00:00","dateModified":"2023-07-23T11:39:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menanyakan beberapa lembar di Google Spreadsheet, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menanyakan-beberapa-lembar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara menanyakan beberapa lembar"}]},{"@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\/2153"}],"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=2153"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2153\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}