QUERY Identifiers Using Column Headers Rather Than Column Letters

16 views
Skip to first unread message

Douglas Parks

unread,
Aug 15, 2016, 5:05:07 PM8/15/16
to Google Visualization API
In trying to learn how to use QUERY, I reviewed the information on the Query Language Reference page <https://developers.google.com/chart/interactive/docs/querylanguage>, but when using the example data and example queries from that page, I receive errors like "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: lunchTime".

Example QUERY:

=QUERY($A$1:$H$7,"select lunchTime, name")

 Is this an issue with the New Google Sheets, or am I missing a clause?


Thanks!
Reply all
Reply to author
Forward
0 new messages