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
3
votes
1 answer

Google Sheets - Query date < doesn't work

I'm using google sheets, and I found that this doesn't work: =QUERY(CSV!1:1000,"select J, AA, AD where Jdate'1900-01-01' and not J>date'2004-01-01'") Can someone please…
user5061526
  • 43
  • 3
3
votes
2 answers

ARRAYFORMULA is only populating the first row

I have financial data that I am trying to summarize in a format that can be used by a line chart. The example spreadsheet is here. In my source data on the left, I have an entry per Date, Symbol, Account. I need to transform this data so there is a…
lvicks
  • 735
  • 1
  • 5
  • 10
3
votes
4 answers

Converting a 2D range into a 1D array with spaces in Google Sheets

I would like to convert a range/array like this | Fruit | Strawberry | | Fruit | Blueberry | | Fruit | Banana | | Vegetable | Lettuce | | Vegetable | Cucumber | | Vegetable | Carrot | | Vegetable | Celery | | Dairy …
Noah Hester
  • 33
  • 3
3
votes
1 answer

Unable to extracted nested data with ImportXML xpath query - google sheets

Hello dear internauts! I want to extract the country distribution from: https://www.etf.com/URTH - "URTH Top 10 Countries" halfway down the page. I intend to expand to other ETFs thereafter: So far, the only things I can imagine are ugly: Searching…
Melvin
  • 33
  • 5
3
votes
1 answer

Google Sheets importXML not working for youtube URLs

Im looking to extract the video title or video description from youtube videos in google sheets. I have the URL and when i write the importxml formula, it keeps just showing me "Share your videos with friends, family, and the world" for the…
Tai
  • 65
  • 2
  • 11
3
votes
1 answer

Autofil columns in one sheet from another only if columns have data AND a specific column has a specific value in Google Sheets

I have a google sheet that autofills rows from another sheet only if the value is a specific column is "approved". =FILTER(Responses!A:AAC,Responses!D:D="Approved") Is it possible to combine this to somehow only display columns that aren't blank.…
NoIdeaWhatImDoing
  • 33
  • 3
3
votes
1 answer

Combine specific columns into one column in Google sheets

I am trying to transpose the data in the table so that Conversion Types are all stacked in one column with corresponding values. Please see the example in this sheet:…
SanLot
  • 65
  • 3
3
votes
2 answers

GoogleFinance: Get History By Month

I use GoogleFinance quite a bit, but from the documentation it seems the only formats to get historical data is by Day or Week. Is there any way to get the data by Month? I guess I could add an extra column, and find the end of each month date to…
maxhugen
  • 1,870
  • 4
  • 22
  • 44
3
votes
3 answers

INNER JOIN in Google Spreadsheets

I don't know or remember the technical name of what I'm looking for but I think an example will be enough for you to understand exactly what I'm looking for. Given table A a x1 b x2 c x1 and Table B x1 x x1 y x1 z x2 p x2 z I Need Table…
White_King
  • 748
  • 7
  • 21
3
votes
1 answer

Unable to parse query string for Function QUERY parameter

Trying to run this query: =query(IMPORTRANGE("XXXXXXX","'XX'!A:H"), "where Col3 = '666' and select Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8 and order by Col5 desc",1) And keep on getting weird errors such as this one Unable to parse query…
user13708028
  • 315
  • 3
  • 13
3
votes
1 answer

Sort Query Pivot Table - Google Sheets

I am trying to sort a query pivot table in order that the columns should be in descending order. I tried:=QUERY({Data!A1:C24},"Select Col1, Sum(Col2) group by Col1 pivot Col3 order by Col1 Desc, Col2 Desc") but it tells me that…
novice
  • 45
  • 1
  • 7
3
votes
1 answer

How to get Consumer Price Index(CPI) in Google Sheets?

Need to get Australia Consumer Price Index(CPI) and update all the prices in my sheet every quarter based on it. Tried to do that using GoogleFinance. Found that its possible to use exchange like ASX for that and indexes from the list. But CPI…
adelak
  • 647
  • 4
  • 11
  • 25
3
votes
1 answer

Google Sheets import range returning incorrect data

The full google spread sheet system is used for score keeping and is prone to delays when updating, however I have never run into an issue like this were the same basic function is returning two separate results. The problem is repeatable and occurs…
FootballGuy
  • 33
  • 3
3
votes
2 answers

Query function to get last row in Google Sheets

I have a sheet where data is updated daily. however, the last integer often ends in between row 131 to 133. how do I run a query function to display the last integer in row 1 column C? I cannot do a simple =A131 on C1 because it can be on A133 the…
sheetsquestions
  • 67
  • 1
  • 4
3
votes
1 answer

How do I select rows, order by date desc in Google Sheets?

I have column A as ID , column B as Score and column C as Date in Google Sheet and I wanted to select the data and ORDER by column C DESC. The result come out as below: A B C 123 100 30/07/19 111 100 30/07/19 113 100 29/07/19 112 100…
aWeakProgrammer
  • 69
  • 2
  • 8
1 2
3
…
74 75