Select clause in a querry returns errors
17 views
Skip to first unread message
David Rajmon
Aug 3, 2016, 9:17:49 AM8/3/16
to Google Visualization API
Query(sheet!a1:w10) returns the whole range as expected.
Query(sheet!a1:w10,"select *") also.
Query(sheet!a1:w10,"select *") also.
When I indicate, which column to select, I get an error saying there is no such column, e.g.
Query(sheet!a1:w10,"select a")
Query(sheet!a1:w10,"select max(a)")
Why?
Any help appreciated. David
Douglas Parks
Aug 15, 2016, 5:22:37 PM8/15/16
to Google Visualization API
The column reference in your formula must match the column letter, including capitalization.
Try using
Query(sheet!a1:w10,"select A")
--
Doug.
David Rajmon
Aug 17, 2016, 10:16:51 AM8/17/16
to Google Visualization API
Thank you Douglas.
It worked.
It worked.
Reply all
Reply to author
Forward
0 new messages