Google表格查询不会显示所有值 [英] Google Sheets query doesn't display all values
问题描述
我有一个Google Sheet，具有以下查询公式:
I have a Google Sheet with the following query formula:
=QUERY('Contact Changes'!B1:T,"SELECT C,D,E,F,G,H,I,J,K,L,M,N,O,R,S WHERE T='RMT'")
通过RMT过滤列T时，源工作表显示以下结果.因此，Query公式应产生相同的结果.
The source sheet displays the following results when filtering column T by RMT. So, the Query formula should produce the same results.
但是，列L当它们是文本值时不显示字段值:
However, column L does not display the field values when they are text values:
如果您查看J126(城市列)，则会看到asdf的值，该已正确显示在结果H2中.但是，结果L2中不会显示L126中的相同值.我可以在此列中显示值的唯一方法是输入数字.
If you look in J126 (city column), you can see the value of asdf which is displayed correctly in the results H2. But, the same value in L126 is not displayed in the results L2. The only way I can get a value to display in this column is by entering numbers.
我有:
- 检查了列数据格式
- 试图删除并重新添加
Query中的列
- 更改列顺序
- 在不同的列中输入相同的值(它们显示在结果中)
- 手动重新输入同一列中的值(它们不会显示在结果中)
- checked the column data format
- tried removing and re-adding the column in the
Query - changing the column order
- entering the same values in a different column (they display in the results)
- manually re-entering the values in the same column (they don't display in the results)
我缺少明显的东西吗?我还能尝试什么?
Am I missing something obvious? What else can I try?
推荐答案
Google表格query每列仅接受一种数据类型，它会自动检测:
Google sheets query accepts only one data type per column, it detects automatically:
- 如果Col包含更多的计票价值:返回文本
- 如果Col包含更多数字:返回数字.
我通过两种解决方法解决了相同的问题:
I solved the same problem with two workarounds:
- 使用
filter或将filter与query组合
- 创建额外的列，并通过将任意char转换为所有值将其转换为文本，然后将其删除.
- use
filteror combinefilterwithquery - make extra column and convert all values into text by adiing any char, and then get rid of it.
https://support.google.com/docs/answer/3093343? hl = zh_CN
在单列中混合使用数据类型的情况下，多数数据类型 确定用于查询目的的列的数据类型.少数民族 数据类型被认为是空值.
In case of mixed data types in a single column, the majority data type determines the data type of the column for query purposes. Minority data types are considered null values.
这篇关于Google表格查询不会显示所有值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
