{"id":1690,"date":"2023-07-25T09:07:49","date_gmt":"2023-07-25T09:07:49","guid":{"rendered":"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/"},"modified":"2023-07-25T09:07:49","modified_gmt":"2023-07-25T09:07:49","slug":"lembar-google-menanyakan-lembar-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/","title":{"rendered":"Google spreadsheet: cara melakukan kueri dari sheet lain"},"content":{"rendered":"

<\/p>\n

\n

Untuk melakukan kueri dari tab lain pada spreadsheet yang sama di Google Spreadsheet, Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n

\n

=query( stats!A1:C9<\/span> , \u201d pilih A, B<\/span> \u201c, 1<\/span> )<\/strong><\/span><\/p>\n<\/blockquote>\n

Ini mengembalikan kolom A<\/strong> dan B<\/strong> dari rentang sel A1:C9<\/strong> di tab bernama stats<\/strong> . Angka 1<\/strong> menentukan bahwa ada 1 baris header di bagian atas kumpulan data yang dikueri.<\/span><\/p>\n

Untuk mengkueri seluruh lembar kerja lain, Anda bisa menggunakan sintaks berikut:<\/span><\/p>\n

\n

=query(importrange(\u201d URL<\/span> \u201c, \u201c stats!A1:C9<\/span> \u201c), \u201c pilih Col1, Col2<\/span> \u201c, 1<\/span> )<\/strong><\/span><\/p>\n<\/blockquote>\n

Ini mengembalikan dua kolom pertama dari rentang sel A1:C9<\/strong> di tab bernama stats<\/strong> dari spreadsheet Google Sheets dengan URL<\/strong> tertentu.<\/span><\/p>\n

Contoh berikut menunjukkan cara menggunakan fungsi-fungsi ini dalam praktik.<\/span><\/p>\n

Contoh: Kueri dari tab di lembar kerja yang sama<\/strong><\/span><\/h3>\n

Katakanlah kita memiliki spreadsheet Google Sheets berikut dengan dua tab:<\/span><\/p>\n

    \n
  • Statistik<\/span><\/strong><\/li>\n
  • daun baru<\/span><\/strong> <\/li>\n<\/ul>\n

    \"\"<\/p>\n

    Untuk mengkueri data di tab statistik<\/strong> dan mengembalikan hasil kueri ke tab lembar_baru<\/strong> , kita bisa mengetikkan rumus berikut di sel A1 pada tab lembar_baru<\/strong> :<\/span> <\/p>\n

    \"\"<\/p>\n

    Contoh: Kueri dari spreadsheet lain<\/strong><\/span><\/h3>\n

    Sekarang katakanlah kita ingin melakukan kueri seluruhnya dari spreadsheet lain. Untuk melakukan ini, kita hanya perlu mengidentifikasi URL spreadsheet Google Sheets yang ingin kita kueri.<\/span><\/p>\n

    Misalnya, data yang kita minati terletak di URL berikut:<\/span> <\/p>\n

    \"\"<\/p>\n

    Kita bisa menggunakan fungsi importrange()<\/strong> untuk menanyakan data di lembar kerja ini:<\/span> <\/p>\n

    \"\"<\/p>\n

    Perhatikan perbedaan halus antara contoh ini dan contoh sebelumnya:<\/span><\/p>\n

      \n
    • Saat membuat kueri dari tab pada lembar kerja yang sama, kami menggunakan pilih A, B<\/strong><\/span><\/li>\n
    • Saat membuat kueri dari lembar kerja yang sepenuhnya berbeda, kami menggunakan pilih Col1, Col2<\/strong><\/span><\/li>\n<\/ul>\n
      \n

      Anda dapat menemukan tutorial Google Sheets lainnya di halaman ini .<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

      Untuk melakukan kueri dari tab lain pada spreadsheet yang sama di Google Spreadsheet, Anda dapat menggunakan sintaks berikut: =query( stats!A1:C9 , \u201d pilih A, B \u201c, 1 ) Ini mengembalikan kolom A dan B dari rentang sel A1:C9 di tab bernama stats . Angka 1 menentukan bahwa ada 1 baris header di bagian atas kumpulan […]<\/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":"\nGoogle Spreadsheet: Cara melakukan kueri dari sheet lain - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan query dari sheet lain di 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\/lembar-google-menanyakan-lembar-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara melakukan kueri dari sheet lain - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan query dari sheet lain di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T09:07:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/q1.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\/lembar-google-menanyakan-lembar-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/\",\"name\":\"Google Spreadsheet: Cara melakukan kueri dari sheet lain - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T09:07:49+00:00\",\"dateModified\":\"2023-07-25T09:07:49+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan query dari sheet lain di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara melakukan kueri dari sheet lain\"}]},{\"@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 melakukan kueri dari sheet lain - Statorial","description":"Tutorial ini menjelaskan cara melakukan query dari sheet lain di 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\/lembar-google-menanyakan-lembar-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara melakukan kueri dari sheet lain - Statorial","og_description":"Tutorial ini menjelaskan cara melakukan query dari sheet lain di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-25T09:07:49+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/q1.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\/lembar-google-menanyakan-lembar-lain\/","url":"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/","name":"Google Spreadsheet: Cara melakukan kueri dari sheet lain - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T09:07:49+00:00","dateModified":"2023-07-25T09:07:49+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan query dari sheet lain di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara melakukan kueri dari sheet lain"}]},{"@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\/1690"}],"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=1690"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1690\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}