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

Google Sheets - Query Multiple Sheets That Have Different Structure

Seeking assistance regarding how to structure a query that will be processing data from multiple sheets (ie tabs), however both sheets have different data structure. The first query (below) queries a tab that contains all of my expenses itemised.…
raym01
  • 73
  • 7
2
votes
1 answer

Google Sheets Unable to parse query string for Function QUERY parameter 2: NO_COLUMN:

So I am trying to query data from Sheet2 to another using parameters from Sheet1 and the query works fine for the first parameter but the second parameter I get the error message Unable to parse query string for Function QUERY parameter 2:…
TJ Weems
  • 1,086
  • 3
  • 21
  • 37
2
votes
1 answer

Google Sheets Query - Not like partial match

So I have this formula, and it's working as intended but I would like to further refine the data. Formula: =QUERY('Users'!A1:Q, "Select A,B,C,F,G,O,Q where Q >= 180 and Q < 44223") I have tried: =QUERY('Users'!A1:Q, "Select A,B,C,F,G,O,Q where Q >=…
SL8t7
  • 617
  • 2
  • 9
  • 27
2
votes
1 answer

google sheets additional custom column in filter

I like to add an additional column in filter formula. This one is working, but not exactly what i need: =FILTER({detroit!A2:N,"detroit"&row(detroit!A2:A)},detroit!A2:A<>"") I need only the text "detroit" without the row number, something like…
dessu
  • 51
  • 7
2
votes
1 answer

Exclude certain class of table data from XMLIMPORT

I'm trying to retrieve the data from the table on this website, in Sheets: https://www.basketball-reference.com/leagues/NBA_2021_totals.html When I use this simple formula: =IMPORTXML(A1,"//tr"), I am able to get the whole table BUT it is including…
mubambi
  • 39
  • 3
2
votes
6 answers

ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets

as per example: A B C D E F G ∞ |======|=======|=====|=====|=====|=====|=====|===== 1 | |AVERAGE| | | | | | |======|=======|=====|=====|=====|=====|=====|===== 2 | xx 1 | …
player0
  • 124,011
  • 12
  • 67
  • 124
2
votes
3 answers

google sheets query left join one-to-many

I have 2 tables and I am trying to perform a left join using google query language,or any formula that could output the result set. Table1 Table2 Result set How can I accomplish that ? Regards
Jonathan Livingston Seagull
  • 844
  • 10
  • 22
2
votes
4 answers

Combine duplicate rows in column as comma separated values - Google Query

If i have 2 columns viz., ID & Name, ID column containing duplicates, and if i want to group by ID to get unique ID's but name column should be a comma-separated list, can this be possible in Google Query? | ID | Name | =============== | 1001 |…
sifar
  • 1,086
  • 1
  • 17
  • 43
2
votes
1 answer

Col BY causing parse error in Google sheets query

I'm trying to run the following Query in google sheets, but am receiving a parse error when I try to select the column BY. Without this column, it runs as expected. Query below: =QUERY('Applications received'!B:DL,"Select B,CT,CU,CV,CW,CX,BY where B…
Tyler
  • 23
  • 2
2
votes
1 answer

Query and Today Function

This formula should filter all results between today and 7 days from now from another sheet but it gives a Formula parse error: =QUERY(Sheet2!A3:H13;"SELECT A, B, C, D, E, F, G, H WHERE (A >= date '"&text(TODAY(),"yyyy-MM-dd")&"' AND A <= date…
Preack
  • 123
  • 7
2
votes
1 answer

Google sheets =QUERY() matching names on two sheets

I've hesitated to ask since this seems so simple of a formula but I've been having difficulty getting it to function. Data is imported from a different workbook to sheet1 and a different set of data is imported to sheet2. Now, I am attempting to…
BoredRoofer
  • 35
  • 5
2
votes
3 answers

Is there a way in google sheets to select a list of cells as an array to be used as a parameter in a connected sheet?

I have a new google sheet set up to query my database via a connected sheet. The query returns a list of our shops and their sales per year. Each shop has an ID. I am able to set Cell A1 in another, reference sheet, to be a parameter in the query.…
Rory Buchanan
  • 21
  • 3
2
votes
2 answers

How do I modify my Google App Query formula to convert empty cells in every row of a specific column to be numeric format?

Im trying to filter a data from another spreadsheet. This is the query of what I'm trying to filter: QUERY(IMPORTRANGE("sheet_name", "Social media posts!A:AS"),"SELECT Col1, Col14, Col12, Col10, Col23, Col16, Col13, Col37, Col2, Col3 WHERE…
Jcbyte
  • 207
  • 1
  • 4
  • 11
2
votes
1 answer

Google Query Return Top N results per category

I have a Google Spreadsheet with several tabs (same columns, split up based on country) https://docs.google.com/spreadsheets/d/1I4cS4oNjCFZ7dWF78rBv6cdHkyWHAF8rGoIlt0941aI/edit?usp=sharing I need to have this data copied to my "Master" sheet where I…
Michael Elebiju
  • 37
  • 4
2
votes
2 answers

Google sheets plot frequency per day in a chart

I am trying to plot frequency per day from a column in a chart. The column has entries for multiple dates of month and may have multiple entries per day. I want to plot those in a chart . Using X-axis as the date. I have explored multiple options…
CodeMonkey
  • 2,265
  • 9
  • 48
  • 94
1 2 3
…
74 75