{"id":3710,"date":"2023-07-16T00:19:16","date_gmt":"2023-07-16T00:19:16","guid":{"rendered":"https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/"},"modified":"2023-07-16T00:19:16","modified_gmt":"2023-07-16T00:19:16","slug":"kueri-google-sheets-atau-dalam-daftar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/","title":{"rendered":"Kueri google spreadsheet: cara menggunakan where in dalam daftar"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut dalam kueri Google Spreadsheet untuk mengembalikan semua baris yang kolomnya berisi nilai dalam daftar:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span dir=\"auto\" style=\"color: #ff6600;\">A1:C11<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">SELECT * WHERE A MATCHES '(value1|value2|value3)'<\/span> \"<\/span> )\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kueri khusus ini akan mengembalikan semua baris dalam rentang <strong>A1:C11<\/strong> dengan nilai di kolom A sama dengan <strong>value1<\/strong> , <strong>value2<\/strong> atau <strong>value3<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : <strong>|<\/strong> Operator berarti \u201cATAU\u201d di Google Spreadsheet.<\/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 daftar WHERE IN 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;\">Kita bisa menggunakan kueri berikut untuk mengembalikan semua baris yang nilainya di kolom &#8220;Tim&#8221; sama dengan Mavs, Magic, Kings, atau Lakers:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span dir=\"auto\" style=\"color: #ff6600;\">A1:C11<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">SELECT * WHERE A MATCHES '(Mavs|Magic|Kings|Lakers)'<\/span> \"<\/span> ) \n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan kueri ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30294 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inlist1.jpg\" alt=\"Kueri Google Spreadsheet ada di daftar\" width=\"665\" height=\"538\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa satu-satunya baris yang dikembalikan adalah baris yang nilainya di kolom &#8220;Tim&#8221; sama dengan Mavs, Magic, Kings, atau Lakers.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda juga dapat menggunakan sintaks serupa untuk menemukan baris yang kolomnya berisi salah satu dari beberapa nilai numerik.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita bisa menggunakan kueri berikut untuk mengembalikan semua baris dengan nilai di kolom &#8220;Poin&#8221; adalah 19, 20, atau 22:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=QUERY( <span dir=\"auto\" style=\"color: #ff6600;\">A1:C11<\/span> , <span class=\" string \" dir=\"auto\">\" <span style=\"color: #008000;\">SELECT * WHERE C MATCHES '(19|20|22)'<\/span> \"<\/span> ) \n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tangkapan layar berikut menunjukkan cara menggunakan kueri ini dalam praktiknya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30295 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/inlist2.jpg\" alt=\"\" width=\"556\" height=\"520\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kueri hanya mengembalikan baris yang nilainya di kolom &#8220;Poin&#8221; sama dengan 19, 20, atau 22.<\/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 berikut dalam kueri Google Spreadsheet untuk mengembalikan semua baris yang kolomnya berisi nilai dalam daftar: =QUERY( A1:C11 , &#8221; SELECT * WHERE A MATCHES &#8216;(value1|value2|value3)&#8217; &#8221; ) Kueri khusus ini akan mengembalikan semua baris dalam rentang A1:C11 dengan nilai di kolom A sama dengan value1 , value2 atau value3 . Catatan [&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 menggunakan WHERE IN dalam daftar - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan sintaks daftar WHERE IN dalam kueri Google Spreadsheet, dengan 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\/kueri-google-sheets-atau-dalam-daftar\/\" \/>\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 WHERE IN dalam daftar - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan sintaks daftar WHERE IN dalam kueri Google Spreadsheet, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T00:19:16+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\/kueri-google-sheets-atau-dalam-daftar\/\",\"url\":\"https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/\",\"name\":\"Kueri Google Spreadsheet: Cara menggunakan WHERE IN dalam daftar - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T00:19:16+00:00\",\"dateModified\":\"2023-07-16T00:19:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan sintaks daftar WHERE IN dalam kueri Google Spreadsheet, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kueri google spreadsheet: cara menggunakan where in dalam daftar\"}]},{\"@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 WHERE IN dalam daftar - Statorial","description":"Tutorial ini menjelaskan cara menggunakan sintaks daftar WHERE IN dalam kueri Google Spreadsheet, dengan 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\/kueri-google-sheets-atau-dalam-daftar\/","og_locale":"id_ID","og_type":"article","og_title":"Kueri Google Spreadsheet: Cara menggunakan WHERE IN dalam daftar - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan sintaks daftar WHERE IN dalam kueri Google Spreadsheet, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/","og_site_name":"Statorials","article_published_time":"2023-07-16T00:19:16+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\/kueri-google-sheets-atau-dalam-daftar\/","url":"https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/","name":"Kueri Google Spreadsheet: Cara menggunakan WHERE IN dalam daftar - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T00:19:16+00:00","dateModified":"2023-07-16T00:19:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan sintaks daftar WHERE IN dalam kueri Google Spreadsheet, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kueri-google-sheets-atau-dalam-daftar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Kueri google spreadsheet: cara menggunakan where in dalam daftar"}]},{"@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\/3710"}],"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=3710"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3710\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}