Please consider the following Google Spreadsheet Formula: =QUERY(    ARRAYFORMULA({            IMPORTRANGE(f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU,Sample!A1:A),            IMPORTRANGE(f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU,Sample!SB1:SB),            IMPORTRANGE(f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU,Sample!SA1:SA),            IMPORTRANGE(f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU,Sample!CY1:GP)    }),    SELECT * WHERE Col2 <> 0 AND Col1 IS NOT NULL,1)The Query expression won't work. I've tried to modify everything with it, but it always yields the same results. Is this caused by the interaction between QUERY() and ARRAYFORMULA, or by {}?In other cases I would prefer doing this by importing the whole range and selecting the Cols as i please, but keep in mind that the last imported range adds up to 96 Columns, so this solution grows unpractical pretty fast. Any ideas how to fix this?
QUERY() ignores query when combined with array
google spreadsheets;google spreadsheets query
Ok, so I've figured it out somehow by adding an extra array {}. No idea why this is working, but hey... =QUERY({    ARRAYFORMULA({            IMPORTRANGE(f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU,Sample!A1:A),            IMPORTRANGE(f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU,Sample!SB1:SB),            IMPORTRANGE(f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU,Sample!SA1:SA),            IMPORTRANGE(f333fHFF5sf6YxO4342Y4BIV3242KJTaarqU,Sample!CY1:GP)    })},    SELECT * WHERE Col2 <> 0 AND Col1 IS NOT NULL,1)