CODEWITHSUNDEEP
google-sheetssyntaxgoogle-sheets-formulagoogle-query-languagereserved-words
Tyler
Tyler

Reputation: 33

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 is not null order by CX")

Any help is much appreciated!

Upvotes: 3

Views: 293

Answers (1)

player0
player0

Reputation: 1

BY column needs to be escaped with `:

=QUERY('Applications received'!B:DL,
 "select B,CT,CU,CV,CW,CX,`BY` 
  where B is not null 
  order by CX")

enter image description here

https://developers.google.com/chart/interactive/docs/querylanguage#reserved-words

Upvotes: 3

Related Questions