例如,我想从12张表中查询数据:
{query 1; query 2; query 3; query 4; query 5; ... } and so on.
其中一些床单可能还不存在。假设查询4和查询5失败,我仍然希望它能够显示来自查询1、查询2和查询3的数据。我希望这样实现:
{IFERROR(query 1, {}); IFERROR(query 2, {}); IFERROR(query 3, {})}
其中{}是一个空范围。或者像这样:
query({IFERROR('Sheet 1'!A1:B100, {}); IFERROR('Sheet 2'!A1:B100, {}) "select * where ...")
但是当我这样做的时候,我得到了一个Array_Literal错误。
有可能做这样的事吗?
尝试在{}范围内添加"。例如,如果有6行返回,则
{IFERROR(query 1, {"","","","","",""}); IFERROR(query 2, {"","","","","",""}); IFERROR(query 3, {"","","","","",""})}
希望这能有所帮助!