如何将这两个查询合并到1个谷歌表单中

Question

我正在寻找一种方法，将以下两个查询用于1。我尝试了很多，但每次都会出错。我也在谷歌上搜索过，但一无所获。将感谢您的帮助

1号

=ARRAYFORMULA(UPPER(QUERY({IMPORTRANGE(Links!D10,"Sheet16!A3:AX1000"),IF(ISDATE_STRICT(IMPORTRANGE(Links!D10,"Sheet16!G3:G1000")),"No Show","Checked")}, "Select Col1, Col10, Col44, Col11, Col12, Col13, Col14, Col18, Col20, Col21, Col22, Col23, Col25, Col27, Col28, Col29, Col32, Col33, Col34, Col35, Col38, Col39, Col40, Col41, Col42, Col43 WHERE Col12 is not null ORDER BY Col10",0)))

否。2

=ARRAYFORMULA(UPPER(QUERY({IMPORTRANGE(Links!D11,"Sheet16!A3:AX1000"),IF(ISDATE_STRICT(IMPORTRANGE(Links!D11,"Sheet16!G3:G1000")),"No Show","Checked")}, "Select Col1, Col10, Col44, Col11, Col12, Col13, Col14, Col18, Col20, Col21, Col22, Col23, Col25, Col27, Col28, Col29, Col32, Col33, Col34, Col35, Col38, Col39, Col40, Col41, Col42, Col43 WHERE Col12 is not null ORDER BY Col10",0)))

Answer 1

try:

=ARRAYFORMULA(UPPER(QUERY({{
IMPORTRANGE(Links!D10, "Sheet16!A3:AX1000"); 
IMPORTRANGE(Links!D11, "Sheet16!A3:AX1000")}, IF(ISDATE_STRICT({
IMPORTRANGE(Links!D10, "Sheet16!G3:G1000"); 
IMPORTRANGE(Links!D11, "Sheet16!G3:G1000")}), "No Show", "Checked")}, 
"select Col1,Col10,Col44,Col11,Col12,Col13,Col14,Col18,Col20,Col21,Col22,Col23,Col25,Col27,Col28,Col29,Col32,Col33,Col34,Col35,Col38,Col39,Col40,Col41,Col42,Col43 
where Col12 is not null 
order by Col10", 0)))