我正在嘗試將資料從一張紙拉到另一張紙上，但只有特定的列，但它不起作用。
=QUERY({ IMPORTRANGE("https://docs.google.com/spreadsheets/d/14BJcO6IzT4t4ioryXivFqSEljTDPukmxTaqKV6z10U0","Pallets Total!A:B"); IMPORTRANGE("https://docs.google.com/spreadsheets/d/14BJcO6IzT4t4ioryXivFqSEljTDPukmxTaqKV6z10U0","Pallets Total!F:H"); IMPORTRANGE("https://docs.google.com/spreadsheets/d/14BJcO6IzT4t4ioryXivFqSEljTDPukmxTaqKV6z10U0","Pallets Total!O:Q") }, "WHERE Col2 = '"&TEXTJOIN("' OR Col2 = '", TRUE, A:A)&"'", 0)
我試圖只命名 Importrange 中的不同列或使用查詢本身并在col
此處命名不同的列：
=QUERY({ IMPORTRANGE("https://docs.google.com/spreadsheets/d/14BJcO6IzT4t4ioryXivFqSEljTDPukmxTaqKV6z10U0!A:Q")}, "WHERE Col2 = '"&TEXTJOIN("' OR Col2 = '", TRUE, A:A), "select Col1, Col2, Col6, Col7, Col8, Col15, Col16, Col17",1)
在夏天：
當我將 PalletID 放入此作業
更新：
=QUERY({IMPORTRANGE("14BJcO6IzT4t4ioryXivFqSEljTDPukmxTaqKV6z10U0", "Pallets Total!A:Q")},
"select Col1,Col2,Col6,Col7,Col8,Col15,Col16,Col17
where Col2 matches '"&TEXTJOIN("|", 1, A2:A)&"'", 0)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/441581.html