我有這 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{}但沒有一個有效。
我究竟做錯了什么？
uj5u.com熱心網友回復：
嘗試：
=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)})
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/487574.html
上一篇：簡化elif