Unable to parse query string

Question

I'm trying to use this function, however, it's not working and giving me the error

"Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: A"

I'd appreciate any help!

=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1zGAiiV_vJba_VnCnJAwHHtZAL_GW_SbsHzKYAMRB3w0/edit#gid=614551224", "Sokkary!A:K"),"Select A,B,D,E,I,J,K where B >= date '"&TEXT(DATEVALUE("03/04/2024"),"yyyy-mm-dd")&"'")

z.. · Accepted Answer · 2024-03-07 14:31:52Z

1

You need to use Col# notation:

"A,B,D,E,I,J,K" becomes "Col1,Col2,Col4,Col5,Col9,Col10,Col11"

So the final formula becomes:

=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1zGAiiV_vJba_VnCnJAwHHtZAL_GW_SbsHzKYAMRB3w0/edit#gid=614551224", "Sokkary!A:K"),"Select Col1,Col2,Col4,Col5,Col9,Col10,Col11 where Col2 >= date '"&TEXT(DATEVALUE("03/04/2024"),"yyyy-mm-dd")&"'")

answered Mar 7, 2024 at 14:31

z..

14k2 gold badges10 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Unable to parse query string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related