我正在尝试在 google 表格中运行以下查询,但当我尝试选择 BY 列时收到解析错误。如果没有此列,它将按预期运行。
查询如下:
=QUERY('Applications received'!B:DL,"Select B,CT,CU,CV,CW,CX,BY where B is not null order by CX")
任何帮助深表感谢!
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")
https://developers.google.com/chart/interactive/docs/querylanguage#reserved-words https://developers.google.com/chart/interactive/docs/querylanguage#reserved-words
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)