返回

数组-垂直组合查询结果

发布时间:2022-06-08 21:32:37 183

我想将以下两个查询合并到一张表中:

查询#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封装每个查询,并将;{}但这些都不起作用。

我做错了什么?

特别声明:以上内容(图片及文字)均为互联网收集或者用户上传发布,本站仅提供信息存储服务!如有侵权或有涉及法律问题请联系我们。
举报
评论区(1)
按点赞数排序
用户头像
相关帖子