带有IMPORTRANGE的QUERY返回“无法解析查询字符串...". [英] QUERY with IMPORTRANGE returns "Unable to parse query string ..."

问题描述

我们目前正在尝试设置以下公式:

We are currently trying to set up the following formula:

=QUERY(IMPORTRANGE("1uyazplHdGpZeBZWOv3TbnIUfWeHQGyZF5mRsNuWxkO4","Data Salesforce!A:Z"),"Select A Where J = 'Spain'",-1)

这个想法是寻找一个来自IMPORTRANGE的数据的查询.

The idea is to look for a QUERY with data coming from an IMPORTRANGE.

我们收到以下错误:

无法解析功能QUERY参数2的查询字符串: NO_COLUMNA

Unable to parse query string for Function QUERY parameter 2: NO_COLUMNA

有什么想法我们可以解决吗?

Any idea how we could resolve it?

推荐答案

与其通过字母顺序索引标识列，不如通过数字索引来引用列.

Instead of identifying the columns by Alphabetical index you need to reference them by numerical index.

我认为这是因为importrange()并不真正导入范围，而只是导入值.
尝试

I assume this is because importrange() doesn't really import the range but just the values.
Try

=QUERY(IMPORTRANGE("1uyazplHdGpZeBZWOv3TbnIUfWeHQGyZF5mRsNuWxkO4","Data Salesforce!A:Z"),"Select Col1 Where Col8 = 'Spain'",-1)

这篇关于带有IMPORTRANGE的QUERY返回“无法解析查询字符串...".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！