如何将这两个查询合并到 1 个 Google 表格中

HSHO 发表于 Dev

HSHO

我正在寻找一种将以下两个查询用于 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)))

玩家0

尝试：

=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)))

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。