Stack Overflow
Stack Overflow

Questions tagged [google-query-language]

Google Query Language is the part of the Google Visualization API that lets the developer perform various data manipulations with the query to the data source. This could also be used in the Google Sheets QUERY built-in function.

Google Query Language allow developers to perform various data manipulations using a syntax very similar to the SQL syntax. It's part of the and can be used in through the QUERY built-in function.

Before posting a question about the Google Query Language check the reference documentation.

1114 questions
1
vote
2 answers

XPath text() returns an extra blank value

I'm scraping this site, specifically the content of the tables inside the div tags with class containing 'ranking-data'. So for the first td that would be: //div[contains(@class, 'ranking-data')]//tr[th//text()[contains(.,…
curropar
  • 334
  • 2
  • 17
1
vote
1 answer

Google Query Language: How to average multiple columns when each one has a different condition?

The data I have a table as the following in Google Sheets: Month Country Metric…
Martian Arts
  • 13
  • 3
1
vote
4 answers

how to concat/merge two columns with different length?

I'm new to google sheet. I have a column(E) with the date and another with a session(F), I want to merge them into one column with each date & different session just like the first few rows in column C. I've tried…
Teresa
  • 13
  • 2
1
vote
2 answers

How do I write a Query in G Sheets with multiple criteria, which also references a cell?

I am trying to write a Query in Google Sheets using the following formula: =QUERY(Input!A2:AD,"SELECT Col1, Col4, Col5, Col6, Col7, Col12, Col13 WHERE Col12 > 200 AND Col30 = '"&B3&"' ORDER BY Col13 DESC LIMIT 10") I have also…
Dan87
  • 13
  • 2
1
vote
1 answer

Google sheets query different sheets from named range in dropdown

I have 2 sheets (sheet1 and sheet2) and have created named ranges for each of them named sheet1 and sheet2. To query sheet1 i use the following formula: =QUERY(sheet1, "select A,B,C") When i want to query sheet2 i have to edit my query formula. I…
chappers
  • 466
  • 1
  • 6
  • 17
1
vote
2 answers

Filter Data in Googlesheets

I have to face some problem about my Googlesheets Data. I want to filter my googlesheets data between two dates and also filter more conditions at the same time in same sheets. Below are given some sample…
Anikul Islam Shuvo
  • 13
  • 2
1
vote
1 answer

Using Arithmetic Operators for null values in GSheets Query Function

Looking to aggregate a total in a query function pivot result. However, where there are null values in Col2 and Col3 after I pivot, the total value results in null. How can I substitute null values in the query function for zero values to allow the…
Content_Type6
  • 13
  • 3
1
vote
1 answer

getting sum of item quantities grouped by item groups

I have the following data: LOC ITEM GROUP MONTH PCS X A1 A 01/01/2022 8 Y A1 A 01/01/2022 76 Z A1 A 01/01/2022 11 X A2 A 01/01/2022 9 Y A2 A 01/01/2022 19 Z A2 A 01/01/2022 13 I need to get the sum of PCS for each LOC/ MONTH…
Nicola Bertellini
  • 25
  • 1
  • 4
1
vote
1 answer

Append the results of to 'Unique' formulas and order by date in google sheets

I have two Goole Sheet queries which both work as required my remaining challenge is to combine the results of both and order by date. my two queries are: =UNIQUE(FILTER({'My Data'!B13:B, 'My Data'!F13:F, 'My Data'!N13:N, 'My Data'!L13:L, 'My…
Adrian
  • 1,089
  • 24
  • 51
1
vote
1 answer

How to Importrange + CountIf on Google Sheets

I need to import information from another google sheet, COUNTIF that information under the criteria of one column saying "VIL" and another column saying "Pass" I am using variations of the below: =countifs((IMPORTRANGE(E65,…
ADAS22
  • 13
  • 3
1
vote
1 answer

ARRAY_LITERAL Error using 3 QUERY with month and year

I'm trying to use a google sheet formula to import data from 3 differente sheets using query with month and year. I used to use the query only with month and it works fine...I add "...and year(Col2)=2022" and now doesn't work. The old code working…
Carlos Vergara
  • 55
  • 4
1
vote
1 answer

ArrayFormula For Join A Range Column

I want to use ArrayFormula for JoinText for multiple columns, From Column A to Column H. I already have Google App Script for it, and it works. var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("DISPOSISI"); const rowNo =…
PSAB Plalangan
  • 127
  • 7
1
vote
2 answers

Google Sheets: How to auto split a data set in half to create a control and test group based on a column variable?

I am looking to split a data set in half (consisting of 1000's rows) automatically as the same action needs to be done daily. The difficulty is that I need each Slot start time segment to be halved and separated so that there is a control group and…
Gavin
  • 13
  • 4
1
vote
1 answer

How to list data from another sheet depending on the date

I’m trying to create a sheet that lists entries depending on the month. As seen in the code below, I want it to look for which month is selected on the Summary sheet (in cell H2) and then display the correct data from the Data sheet according to the…
user3711291
  • 21
  • 4
1
vote
1 answer

How can I auto fill a formula with dynamic value in array in the same cell?

so I have a formula inside an array that looks like this ={CRYPTOFINANCE("kraken:"&ARL8&"/USD", "price_history", "10d")} I want to auto fill the array with the same function but with the 'ARL8' reference in an ascending order, just like auto…
boten500
  • 123
  • 1
  • 1
  • 8
1 2 3
…
74 75