3

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!

Improve this question

1 Answer 1

Reset to default
3

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.