{"id":3422,"date":"2023-07-17T13:56:37","date_gmt":"2023-07-17T13:56:37","guid":{"rendered":"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/"},"modified":"2023-07-17T13:56:37","modified_gmt":"2023-07-17T13:56:37","slug":"hapus-permintaan-google-sheets-dari-header","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/","title":{"rendered":"Kueri google spreadsheet: cara menghapus header dari hasil"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan rumus berikut untuk menghapus label header dari hasil kueri Google Spreadsheet:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Hapus header kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 16px;\"> <strong><span class=\" string \" dir=\"auto\">=QUERY( <span style=\"color: #ff9900;\">A1:C7<\/span> ,\" <span style=\"color: #008000;\">select A, sum(B) group by A label sum(B) ''<\/span> \")\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghapus header dari kolom kedua hasil kueri.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Hapus Header dari Beberapa Kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 16px;\"> <strong><span class=\" string \" dir=\"auto\">=QUERY( <span style=\"color: #ff9900;\">A1:C7<\/span> ,\" <span style=\"color: #008000;\">select A, sum(B), sum(C) group by A label sum(B) '', sum(C) '' \")<\/span>\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghapus header dari kolom kedua dan ketiga hasil kueri.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Hapus Header dari Semua Kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 16px;\"> <strong><span class=\" string \" dir=\"auto\">=QUERY(QUERY( <span style=\"color: #ff9900;\">A1:C7<\/span> , \" <span style=\"color: #008000;\">select A, sum(B) group by A<\/span> \", <span style=\"color: #3366ff;\">1<\/span> ), \" <span style=\"color: #008000;\">select * offset 1<\/span> \", <span style=\"color: #3366ff;\">0<\/span> )\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghapus header dari semua kolom di hasil kueri.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap rumus dengan kumpulan data berikut di Google Spreadsheet:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28678 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/supprimer1-1.jpg\" alt=\"\" width=\"495\" height=\"422\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hapus header kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan query berikut untuk mengembalikan jumlah poin yang dicetak oleh masing-masing tim dan menghapus label header dari kolom jumlah poin:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 16px;\"> <strong><span class=\" string \" dir=\"auto\">=QUERY( <span style=\"color: #ff9900;\">A1:C7<\/span> ,\" <span style=\"color: #008000;\">select A, sum(B) group by A label sum(B) ''<\/span> \")<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-28680\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/supprimer2-1.jpg\" alt=\"Kueri Google Spreadsheet menghapus header dari hasil\" width=\"584\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa tidak ada label header untuk kolom jumlah.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kami sebenarnya mengganti label yang tadinya merupakan <strong>jumlah Poin<\/strong> s dengan label kosong.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hapus header dari beberapa kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kueri berikut untuk mengembalikan jumlah poin dan jumlah assist untuk setiap tim dan menghapus label header dari setiap kolom yang dijumlahkan.<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 16px;\"> <strong><span class=\" string \" dir=\"auto\">=QUERY( <span style=\"color: #ff9900;\">A1:C7<\/span> ,\" <span style=\"color: #008000;\">select A, sum(B), sum(C) group by A label sum(B) '', sum(C) '' \")<\/span><\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28681 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/supprimer3-1.jpg\" alt=\"\" width=\"677\" height=\"486\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa tidak ada label header untuk kolom jumlah poin atau jumlah assist.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Hapus header dari semua kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kueri berikut untuk mengembalikan jumlah poin yang dicetak oleh masing-masing tim dan menghapus label header dari setiap kolom yang dihasilkan:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 16px;\"> <strong><span class=\" string \" dir=\"auto\">=QUERY(QUERY( <span style=\"color: #ff9900;\">A1:C7<\/span> , \" <span style=\"color: #008000;\">select A, sum(B) group by A<\/span> \", <span style=\"color: #3366ff;\">1<\/span> ), \" <span style=\"color: #008000;\">select * offset 1<\/span> \", <span style=\"color: #3366ff;\">0<\/span> )<\/span><\/strong> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28682 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/supprimer4.jpg\" alt=\"\" width=\"672\" height=\"484\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa tidak ada label header untuk kolom mana pun 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 menurut<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan rumus berikut untuk menghapus label header dari hasil kueri Google Spreadsheet: Metode 1: Hapus header kolom =QUERY( A1:C7 ,&#8221; select A, sum(B) group by A label sum(B) &#8221; &#8220;) Contoh khusus ini menghapus header dari kolom kedua hasil kueri. Metode 2: Hapus Header dari Beberapa Kolom =QUERY( A1:C7 ,&#8221; select A, sum(B), [&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 Menghapus Header dari Hasil - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus header dari hasil query Google Sheets, 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\/hapus-permintaan-google-sheets-dari-header\/\" \/>\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 Menghapus Header dari Hasil - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus header dari hasil query Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T13:56:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/supprimer1-1.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/\",\"url\":\"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/\",\"name\":\"Kueri Google Spreadsheet: Cara Menghapus Header dari Hasil - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T13:56:37+00:00\",\"dateModified\":\"2023-07-17T13:56:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus header dari hasil query Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara menghapus header dari hasil\"}]},{\"@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 Menghapus Header dari Hasil - Statorial","description":"Tutorial ini menjelaskan cara menghapus header dari hasil query Google Sheets, 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\/hapus-permintaan-google-sheets-dari-header\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara Menghapus Header dari Hasil - Statorial","og_description":"Tutorial ini menjelaskan cara menghapus header dari hasil query Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/","og_site_name":"Statorials","article_published_time":"2023-07-17T13:56:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/supprimer1-1.jpg"}],"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\/hapus-permintaan-google-sheets-dari-header\/","url":"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/","name":"Kueri Google Spreadsheet: Cara Menghapus Header dari Hasil - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T13:56:37+00:00","dateModified":"2023-07-17T13:56:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus header dari hasil query Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara menghapus header dari hasil"}]},{"@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\/3422"}],"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=3422"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3422\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}