Google Sheets Query ImportRange where Col = Column(NamedRange)-CodePudding

=QUERY( IMPORTRANGE( "https://URL", "Name Of Sheet!1:999" ), "SELECT * WHERE Col" & COLUMN(namedRange) & "'is not null",0 )

This spits out the error of:

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " <ID> "Col1 "" at line 1, column 16. Was expecting one of: "(" ... "(" ...

I know part of the solution is working with the "&" symbol to join certain blocks of quotes. The biggest challenge is putting the right quotation marks in the right spot.

CodePudding user response：

try:

=QUERY({IMPORTRANGE("id", "Name Of Sheet!1:999")}, 
 "where Col"&COLUMN(namedRange)&" is not null", 0)

select * is not needed if you want all columns

https://URL you dont need it either, just put there ID number of the sheet

CodePudding user response：

Assuming the named range is called TEST

"select Col" & COLUMN(TEST) & " where Col" & COLUMN(TEST) & " is not null "

"select * where Col" & COLUMN(TEST) & " is not null "

you have omitted WHERE syntax