{"id":3708,"date":"2023-07-16T00:38:49","date_gmt":"2023-07-16T00:38:49","guid":{"rendered":"https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/"},"modified":"2023-07-16T00:38:49","modified_gmt":"2023-07-16T00:38:49","slug":"nama-kolom-kueri-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/","title":{"rendered":"Cara menggunakan nama kolom di kueri google sheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggunakan nama kolom dalam kueri Google Spreadsheet:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span style=\"color: #ff6600;\">A1:C11<\/span> ,\" <span style=\"color: #008000;\">SELECT<\/span> \"&amp;SUBSTITUTE(ADDRESS( <span style=\"color: #3366ff;\">1<\/span> ,MATCH(\" <span style=\"color: #008000;\">Team<\/span> \", <span style=\"color: #800080;\">A1:C1,0<\/span> <span style=\"color: #3366ff;\">)<\/span> , <span style=\"color: #3366ff;\">4<\/span> ), <span style=\"color: #3366ff;\">1<\/span> ,\"\"))<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kueri khusus ini akan memilih kolom dengan nama \u201cTim\u201d di rentang sel <strong>A1:C11<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Gunakan nama kolom dalam kueri Google Spreadsheet<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30279 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-colonne1.jpg\" alt=\"\" width=\"476\" height=\"475\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita ingin memilih kolom &#8220;Tim&#8221; dalam kueri biasa, kita akan mereferensikan kolom tersebut sebagai <strong>A<\/strong> karena ini adalah kolom pertama dalam rentang yang kita minati:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A1:C11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">SELECT A<\/span> \"<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Ini hanya akan mengembalikan kolom A:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30280 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-colonne2.jpg\" alt=\"\" width=\"596\" height=\"438\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Namun, jika kami mencoba menggunakan &#8220;Tim&#8221; sebagai nama kolom, kami akan menerima pesan kesalahan:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <span style=\"color: #000000;\"><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">QUERY<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">(<\/span> <span dir=\"auto\" style=\"color: #ff6600;\">A1:C11<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">,<\/span> <span class=\" string \" dir=\"auto\">\u201c <span style=\"color: #008000;\">SELECT Team<\/span> \u201d<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30281 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-colonne3.jpg\" alt=\"\" width=\"585\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Sebagai gantinya, kita perlu menggunakan rumus berikut untuk memilih kolom \u201cTim\u201d berdasarkan nama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span style=\"color: #ff6600;\">A1:C11<\/span> ,\" <span style=\"color: #008000;\">SELECT<\/span> \"&amp;SUBSTITUTE(ADDRESS( <span style=\"color: #3366ff;\">1<\/span> ,MATCH(\" <span style=\"color: #008000;\">Team<\/span> \", <span style=\"color: #800080;\">A1:C1,0<\/span> <span style=\"color: #3366ff;\">)<\/span> , <span style=\"color: #3366ff;\">4<\/span> ), <span style=\"color: #3366ff;\">1<\/span> ,\"\"))<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan mengembalikan kolom &#8220;Tim&#8221; dari kumpulan data asli:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30282\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-colonne4.jpg\" alt=\"Nama Kolom Kueri Google Spreadsheet\" width=\"689\" height=\"469\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda dapat menggunakan beberapa fungsi <strong>SUBSTITUTE<\/strong> jika Anda ingin memilih beberapa kolom berdasarkan nama.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda dapat menggunakan sintaks berikut untuk memilih kolom &#8220;Tim&#8221; dan &#8220;Posisi&#8221; berdasarkan nama:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span style=\"color: #ff6600;\">A1:C11<\/span> ,\" <span style=\"color: #008000;\">SELECT<\/span> \"&amp;SUBSTITUTE(ADDRESS( <span style=\"color: #3366ff;\">1<\/span> ,MATCH(\" <span style=\"color: #008000;\">Team<\/span> \", <span style=\"color: #800080;\">A1:C1<\/span> , <span style=\"color: #3366ff;\">0<\/span> ), <span style=\"color: #3366ff;\">4<\/span> ), <span style=\"color: #3366ff;\">1<\/span> ,\"\")&amp;\" <span style=\"color: #008000;\">,<\/span> \"&amp;SUBSTITUTE(ADDRESS( <span style=\"color: #3366ff;\">1<\/span> ,MATCH(\" <span style=\"color: #008000;\">Position<\/span> \", <span style=\"color: #800080;\">A1:C1<\/span> , <span style=\"color: #3366ff;\">0<\/span> ), <span style=\"color: #3366ff;\">4<\/span> ), <span style=\"color: #3366ff;\">1<\/span> ,\"\"))<\/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=\" wp-image-30283 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-colonne5.jpg\" alt=\"\" width=\"689\" height=\"422\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kueri mengembalikan kolom \u201cTim\u201d dan \u201cPosisi\u201d.<\/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 hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/permintaan-tunggal-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara mengembalikan baris unik saja<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hapus-permintaan-google-sheets-dari-header\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: cara menghapus header dari hasil<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/permintaan-google-sheet-abaikan-kosong\/\" target=\"_blank\" rel=\"noopener\">Kueri Google Spreadsheet: Cara Mengabaikan Sel Kosong di Kueri<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menggunakan nama kolom dalam kueri Google Spreadsheet: =QUERY( A1:C11 ,&#8221; SELECT &#8220;&amp;SUBSTITUTE(ADDRESS( 1 ,MATCH(&#8221; Team &#8220;, A1:C1,0 ) , 4 ), 1 ,&#8221;&#8221;)) Kueri khusus ini akan memilih kolom dengan nama \u201cTim\u201d di rentang sel A1:C11 . Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Gunakan [&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 menggunakan nama kolom di kueri Google Spreadsheet \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan nama kolom dalam kueri Google Spreadsheet, beserta 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\/nama-kolom-kueri-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan nama kolom di kueri Google Spreadsheet \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan nama kolom dalam kueri Google Spreadsheet, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T00:38:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-colonne1.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\/nama-kolom-kueri-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/\",\"name\":\"Cara menggunakan nama kolom di kueri Google Spreadsheet \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T00:38:49+00:00\",\"dateModified\":\"2023-07-16T00:38:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan nama kolom dalam kueri Google Spreadsheet, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan nama kolom di kueri google sheets\"}]},{\"@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 menggunakan nama kolom di kueri Google Spreadsheet \u2013 Statorial","description":"Tutorial ini menjelaskan cara menggunakan nama kolom dalam kueri Google Spreadsheet, beserta 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\/nama-kolom-kueri-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan nama kolom di kueri Google Spreadsheet \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan nama kolom dalam kueri Google Spreadsheet, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-16T00:38:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/nom-de-colonne1.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\/nama-kolom-kueri-google-sheet\/","url":"https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/","name":"Cara menggunakan nama kolom di kueri Google Spreadsheet \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T00:38:49+00:00","dateModified":"2023-07-16T00:38:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan nama kolom dalam kueri Google Spreadsheet, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nama-kolom-kueri-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan nama kolom di kueri google sheets"}]},{"@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\/3708"}],"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=3708"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3708\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3708"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3708"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}