数组-垂直组合查询结果
发布时间: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封装每个查询,并将;
和{}
但这些都不起作用。
我做错了什么?
特别声明:以上内容(图片及文字)均为互联网收集或者用户上传发布,本站仅提供信息存储服务!如有侵权或有涉及法律问题请联系我们。
举报