在Google Sheets中,我以前通过Encoded查询函数成功运行了这个查询:
SELECT Q, Y, J WHERE Y IS NOT NULL AND NOT Y LIKE '[%' ORDER BY Q, Y, J
上面的编码查询函数看起来像这样:
SELECT%20Q%2C%20Y%2C%20J%20WHERE%20Y%20IS%20NOT%20NULL%20AND%20NOT%20Y%20LIKE%20'%5B%25'%20ORDER%20BY%20Q%2C%20Y%2C%20J
没事的现在我想go 掉行中数据完全相同的所有结果. 实际上,剥离重复行. 我好像做不到. 我就在这里. 查询功能:
=UNIQUE(QUERY(A2:Y3608,"SELECT Q, Y, J WHERE Y IS NOT NULL AND NOT Y LIKE '[%'ORDER BY Q, Y, J"))
当我将其作为URL运行时(使用编码查询函数),我得到错误:{"version":"0.6","reqId":"0","status":"error","errors":[{"reason":"invalid_QUERY","detailed_message":"Invalid query:Encerted\u0022\u003e\u022UNIQUE\u0022在第1行第1列.\ n正在期待以下之一:\n\u003cEOF\u003e\n\u0022select\u0022...\ n\u0022其中\u0022...\ n\u0022group\u0022...\ n\u0022\u0022...\ n\u0022order\u0022...\ n\u0022跳过\u0022...\ n\u0022limit\u0022...\ n\u0022偏移\u0022...\ n\u0022label\u0022...\ n\u0022格式\u0022...\ n\u0022选项\u0022...\ n "}]}
如何让UNIQUE工作?
谢谢大家,
-裘德-裘德