{"id":2319,"date":"2023-07-22T19:16:31","date_gmt":"2023-07-22T19:16:31","guid":{"rendered":"https:\/\/statorials.org\/id\/label-kueri-google-sheets\/"},"modified":"2023-07-22T19:16:31","modified_gmt":"2023-07-22T19:16:31","slug":"label-kueri-google-sheets","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/label-kueri-google-sheets\/","title":{"rendered":"Kueri google spreadsheet: cara menggunakan klausul label"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan klausa label<\/strong> dalam kueri Google Spreadsheet untuk membuat label khusus untuk hasil di kolom tertentu.<\/span><\/p>\n

Anda bisa menggunakan sintaks berikut untuk membuat label spesifik untuk kolom dalam kueri:<\/span><\/p>\n

 =<\/span> QUERY<\/span> (<\/span> A1:C13<\/span> ,<\/span> \" select * label A 'Column A'<\/span> \"<\/span> )<\/span>\n<\/strong><\/pre>\n
 Dalam contoh ini, kita memilih semua kolom dalam rentang A1:C13 dan memberi label kolom A sebagai “Kolom A” pada keluaran yang dihasilkan.<\/span><\/p>\n
 Anda juga bisa menggunakan sintaks berikut untuk membuat label spesifik untuk beberapa kolom dalam kueri:<\/span><\/p>\n
 =<\/span> QUERY<\/span> (<\/span> A1:C13<\/span> ,<\/span> \" select * label A 'A Column', B 'B Column'<\/span> \"<\/span> )<\/span> \n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan rumus ini dalam praktik.<\/span><\/p>\n
 Contoh 1: Gunakan klausa Label dengan kolom<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan rumus berikut untuk memilih kolom Tim, Poin, dan Rebound, lalu memberi label pada kolom “Tim” sebagai “Nama Tim” pada hasilnya:<\/span> <\/p>\n
\"klausa<\/p>\n
 Perhatikan bahwa kolom “Tim” telah diganti namanya, namun kolom “Poin” dan “Rebound” tetap mempertahankan nama aslinya.<\/span><\/p>\n
 Contoh 2: Gunakan klausa Label dengan banyak kolom<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan rumus berikut untuk memilih kolom Tim, Poin, dan Rebound, lalu memberi label pada kolom “Tim” sebagai “Nama Tim” dan kolom “Poin” sebagai “Poin yang Dicetak” pada hasilnya:<\/span> <\/p>\n
\"\"<\/p>\n
 Dalam contoh ini, kita menggunakan klausa label<\/strong> untuk mengganti nama dua kolom pada output, tapi kita bisa menggunakan sintaks yang sama persis untuk mengganti nama sejumlah kolom yang kita inginkan.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan hal umum lainnya dengan kueri Google Spreadsheet:<\/span><\/p>\n
 Google Spreadsheet: cara melakukan kueri dari sheet lain<\/a>
 Kueri Google Spreadsheet: pilih baris yang berisi string<\/a>
 Kueri Google Spreadsheet: Cara Menggunakan Grup Berdasarkan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan klausa label dalam kueri Google Spreadsheet untuk membuat label khusus untuk hasil di kolom tertentu. Anda bisa menggunakan sintaks berikut untuk membuat label spesifik untuk kolom dalam kueri: = QUERY ( A1:C13 , ” select * label A ‘Column A’ ” ) Dalam contoh ini, kita memilih semua kolom dalam rentang A1:C13 […]<\/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":"\nKueri Google Spreadsheet: Cara Menggunakan Klausul Label - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan klausa label dalam kueri 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\/label-kueri-google-sheets\/\" \/>\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 Menggunakan Klausul Label - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan klausa label dalam kueri Google Spreadsheet, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/label-kueri-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T19:16:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etiquette11.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\/label-kueri-google-sheets\/\",\"url\":\"https:\/\/statorials.org\/id\/label-kueri-google-sheets\/\",\"name\":\"Kueri Google Spreadsheet: Cara Menggunakan Klausul Label - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T19:16:31+00:00\",\"dateModified\":\"2023-07-22T19:16:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan klausa label dalam kueri Google Spreadsheet, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/label-kueri-google-sheets\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/label-kueri-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/label-kueri-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara menggunakan klausul label\"}]},{\"@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 Menggunakan Klausul Label - Statologi","description":"Tutorial ini menjelaskan cara menggunakan klausa label dalam kueri 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\/label-kueri-google-sheets\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara Menggunakan Klausul Label - Statologi","og_description":"Tutorial ini menjelaskan cara menggunakan klausa label dalam kueri Google Spreadsheet, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/label-kueri-google-sheets\/","og_site_name":"Statorials","article_published_time":"2023-07-22T19:16:31+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/etiquette11.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\/label-kueri-google-sheets\/","url":"https:\/\/statorials.org\/id\/label-kueri-google-sheets\/","name":"Kueri Google Spreadsheet: Cara Menggunakan Klausul Label - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T19:16:31+00:00","dateModified":"2023-07-22T19:16:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan klausa label dalam kueri Google Spreadsheet, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/label-kueri-google-sheets\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/label-kueri-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/label-kueri-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara menggunakan klausul label"}]},{"@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\/2319"}],"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=2319"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2319\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}