垂直组合查询结果

Question

我有这2个查询，我想在一张纸上组合在一起：

查询＃1：

=ARRAYFORMULA(QUERY(if(Presentations!G3:G = "Conference presentation", {Presentations!A3:A, Presentations!B3:B, Presentations!C3:C, Presentations!S3:S, Presentations!V3:V, Presentations!K3:K&". "&Presentations!L3:L, Presentations!T3:T}, {Presentations!A3:A, Presentations!B3:B, Presentations!C3:C, Presentations!S3:S, Presentations!V3:V, Presentations!P3:P&". "&Presentations!Q3:Q, Presentations!T3:T}), "select Col1, Col2, Col3, Col4, Col5, Col6, Col7 where Col4 is not null",0))

查询＃2：

=ifna(ARRAYFORMULA(QUERY({'Doc Engagement'!A3:A, 'Doc Engagement'!B3:B, 'Doc Engagement'!C3:C, 'Doc Engagement'!S3:S, 'Doc Engagement'!I3:I, 'Doc Engagement'!G3:G&": "&'Doc Engagement'!H3:H, 'Doc Engagement'!T3:T}, "select Col1, Col2, Col3, Col4, Col5, Col6, Col7 where Col6 is not null",0)))

我尝试用iferror包装每个查询，然后放置;; and {} ，但它们都没有用。

我在做什么错？

Answer 1

尝试：

=ARRAYFORMULA(QUERY({if(Presentations!G3:G = "Conference presentation", {Presentations!A3:A, Presentations!B3:B, Presentations!C3:C, Presentations!S3:S, Presentations!V3:V, Presentations!K3:K&". "&Presentations!L3:L, Presentations!T3:T}, {Presentations!A3:A, Presentations!B3:B, Presentations!C3:C, Presentations!S3:S, Presentations!V3:V, Presentations!P3:P&". "&Presentations!Q3:Q, Presentations!T3:T}); {'Doc Engagement'!A3:A, 'Doc Engagement'!B3:B, 'Doc Engagement'!C3:C, 'Doc Engagement'!S3:S, 'Doc Engagement'!I3:I, 'Doc Engagement'!G3:G&": "&'Doc Engagement'!H3:H, 'Doc Engagement'!T3:T}}, "select Col1, Col2, Col3, Col4, Col5, Col6, Col7 where Col4 is not null",0))

或：

=ARRAYFORMULA({QUERY(if(Presentations!G3:G = "Conference presentation", {Presentations!A3:A, Presentations!B3:B, Presentations!C3:C, Presentations!S3:S, Presentations!V3:V, Presentations!K3:K&". "&Presentations!L3:L, Presentations!T3:T}, {Presentations!A3:A, Presentations!B3:B, Presentations!C3:C, Presentations!S3:S, Presentations!V3:V, Presentations!P3:P&". "&Presentations!Q3:Q, Presentations!T3:T}), "select Col1, Col2, Col3, Col4, Col5, Col6, Col7 where Col4 is not null",0); QUERY({'Doc Engagement'!A3:A, 'Doc Engagement'!B3:B, 'Doc Engagement'!C3:C, 'Doc Engagement'!S3:S, 'Doc Engagement'!I3:I, 'Doc Engagement'!G3:G&": "&'Doc Engagement'!H3:H, 'Doc Engagement'!T3:T}, "select Col1, Col2, Col3, Col4, Col5, Col6, Col7 where Col6 is not null",0)})