2

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!

player0
  • 124,011
  • 12
  • 67
  • 124
Tyler
  • 23
  • 2

1 Answers1

2

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

player0
  • 124,011
  • 12
  • 67
  • 124