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

Count instances of number in Row

I have a sheet formated somewhat like this Thing 5 6 7 Person 1 Person 2 Person 3 Thing 1 1 2 7 7 6 Thing 2 5 5 Thing 3 7 6 6 Thing 4 …
Gronk
  • 381
  • 1
  • 3
  • 12
-1
votes
1 answer

Select 'x' returns "x"()

I want to return 3 columns, A(description), 'D'(hard coded value of D), Q(date) =query('Detailed Plan'!$A$2:$Q, "select A,'D',Q where D = date) It returns the following results. Rows 2 and greater are exactly what I want and would be perfect if I…
iroosma
  • 15
  • 1
  • 4
-1
votes
1 answer

How to use generalized projection in a Google docs query?

I wish to use a generalized projection as follows in a Google query with no success =query('Form Responses 2'!A:N,"Select if(month(F)>6,year(F),year(F)-1) , N,B,C,D,E,F,G,H,I,J,K where F >= date '2011-07-01' and F <= date '2050-06-30' order by F…
Vishal
  • 23
  • 4
-1
votes
1 answer

How to properly structure this query?

How can I structure a query in Google Sheets that will combine cells with the same text (name 1, name 2, etc) and then sum their associated numeric values in column B (sale 1, sale 2, etc) and sort in descending order? The end goal is to use this…
J T
  • 3
  • 1
-1
votes
1 answer

IMPORTRANGE returning NO_COLUMN

I am using: =query(importrange(SHEETID,"Orders!$A$2:$X"),"select Col1 where Col23=0") in a Google Sheets and receiving the following error: Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col23" I have authorized the…
enano2054
  • 329
  • 6
  • 19
-1
votes
1 answer

Only return data from cells with value

I've searched for a solution to this and have come close, but I can't figure out a final solution. I'm new to queries in Google Sheets. I'll include a link to the sheet and the query I'm using. I want my query to only return results from cells with…
Josh
  • 163
  • 1
  • 1
  • 7
-1
votes
1 answer

Google spreadsheet query formula - join like

I got this case: A; B; C; D a; 3; b; 4 e; 6; ; b; 5; c; 6 c; 4; a; 2 d; 5 I would like to build: E; F; G a; 3; 2 b; 5; 4 c; 4; 6 d; ; 5 e; 6; I tried some queries without sucess and didn't found a join simple solution... Can you help me to…
Claire
  • 1
  • 2
-2
votes
1 answer

Putting a Query search inside an array formula in google sheets

I am trying to find a way to consolidate a sheets query and an array formula I apply to said query into a single cell. The intent is to avoid having to display the query to apply the array formula, as I have a number of slightly different queries…
Riley Hull
  • 1
  • 2
-2
votes
1 answer

filter values based on line items with data validation in Google sheet

Data set 1 P1 Type Size Color Material Length Kurta Pyjamas No Sizeethnic_1 Colorethnic_1 Materialethnic_3 Lengthethnic_1 Dhotis Typethnic_1 No Colorethnic_2 Materialethnic_2 No Sherwani No No Colorethnic_2 No Lengthethnic_2 Men…
Sameer Farooqui
  • 117
  • 1
  • 11
-2
votes
1 answer

Sum value of col 3 based on col 1 and col 2 value

I want to sum value of col3 based on col1 and col2 here is the link of dummy data sheet in which I have shown sample table according to which I want sum of col 3 please guys check the sheet and suggest me some solution for…
new1
  • 33
  • 4
-2
votes
2 answers

Ignore blank cells after using Filter in Google Sheets

My Table looks like this This is a result of using =filter('Form Responses 1'!A:BJ,'Form Responses 1'!F:F=subjects!A19) Now all I have to do is, ignore the blank cells and put in the last 3 columns. I mean, columns N,O,P should come to H,I,J and…
Shankar Rajagopal
  • 37
  • 5
-2
votes
2 answers

Querying Fomula cells in Google Sheets

Is it possible to run a query on formula populated cells? Every time I try I get a parse error. Is there a way to run a query on cells that are populated by a formula? or do I need to manually convert formula populated cells to values before running…
Nathanael Phillips
  • 1
-2
votes
1 answer

how to reshape input dataset with formula

I want to work the following. I am using this formula =ARRAYFORMULA(Split(Transpose(Split(Query(Transpose(query(transpose(if(Input!B2:I<>"", ";"&Input!A2:A&"\"&Input!B2:I, )) ,,999^99)),,999^99), ";")), "\")) but it does not give the desired…
user001000
  • 29
  • 3
-2
votes
1 answer

Query a count of unique attributes in a table

I have a table like this: +--------+-------+--------+-------+ | attr1 | attr2 | attr3 | attr4 | +--------+-------+--------+-------+ | purple | wine | clear | 10.0 | | red | wine | solid | 20.0 | | red | beer | cloudy | 10.0 | |…
sifar
  • 1,086
  • 1
  • 17
  • 43
-2
votes
2 answers

How can I import data using query and group it by row values?

I have a table with data which is structured like this: Is it possible to transform my table to table like this using query?
Vidmat
  • 3
  • 2
1 2 3
…
74
75