Getting "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: C" error

Question

I am trying to pull data from a number of sheets to one dashboard sheet. When I add more than sheet I get this error: Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: C

It works fine with only one sheet (July2022) but as soon as I add one or more to it I get the error.

=QUERY({JULY2022!A4:EC34;AUGUST2022!A4:EC34;SEPTEMBER2022!A4:EC34;OCTOBER2022!A4:EC34;NOVEMBER!A4:EC34;DECEMBER!A4:EC34},
"select C, A
where A >= date'"&TEXT(TODAY(),"yyyy-mm-dd")&"'
and C is not null
ORDER BY A ASC LIMIT 8"
)

W.S. · Accepted Answer · 2022-07-01 20:27:59Z

1

When you wrap the data into curly braces, which is necessary when you combine multiple sources, you've to refer to the columns as Col1, Col2, Col3,... You can't use the column letters.

You can use:

=QUERY({JULY2022!A4:EC34;AUGUST2022!A4:EC34;SEPTEMBER2022!A4:EC34;OCTOBER2022!A4:EC34;NOVEMBER!A4:EC34;DECEMBER!A4:EC34},
"select Col3, Col1
where Col1 >= date'"&TEXT(TODAY(),"yyyy-mm-dd")&"'
and Col3 is not null
ORDER BY Col1 ASC LIMIT 8"
)

answered Jul 1, 2022 at 20:27

W.S.

1,5251 gold badge9 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Getting "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: C" error

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