你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn。
Applies to: ✅Microsoft Fabric✅Azure Data Explorer✅Azure Monitor✅Microsoft Sentinel
从输入表中选择要在输出表中排除的列。
Syntax
T| project-awayColumnNameOrPattern [, ...]
Learn more about syntax conventions.
Parameters
| Name | 类型 | Required | Description |
|---|---|---|---|
| T | string |
✔️ | 要从中删除列的表格输入。 |
| ColumnNameOrPattern | string |
✔️ | 要从输出中删除的一个或多个列名或列通配符模式。 |
Returns
一个包含未指定为参数的列的表。 包含与输入表相同的行数。
Tip
可以 project-away 存在于原始表中或已作为查询的一部分进行计算的任何列。
Note
结果中列的顺序取决于列在表中的原始顺序。 仅删除已指定为参数的列。 其他列会包括在结果中。
Examples
The examples in this article use publicly available tables in the help cluster, such as the
StormEventstable in the Samples database.
The examples in this article use publicly available tables, such as the
Weathertable in the Weather analytics sample gallery. 可能需要修改示例查询中的表名称以匹配工作区中的表。
输入表 PopulationData 有两列:State 和 Population。 去掉 Population 列,你将得到一个州名列表。
PopulationData
| project-away Population
Output
下表仅显示前 10 个结果。
| State |
|---|
| ALABAMA |
| ALASKA |
| ARIZONA |
| ARKANSAS |
| CALIFORNIA |
| COLORADO |
| CONNECTICUT |
| DELAWARE |
| 哥伦比亚特区 |
| FLORIDA |
| ... |
使用列名模式去掉
此查询删除以单词“session”开头的列。
ConferenceSessions
| project-away session*
Output
该表仅显示前 10 个结果。
| conference | 所有者 | participants | URL | 水平仪 | starttime | duration | time_and_duration | kusto_affinity |
|---|---|---|---|---|---|---|---|---|
| PASS 峰会 2019 | Avner Aharoni | https://www.eventbrite.com/e/near-real-time-interact-analytics-on-big-data-using-azure-data-explorer-fg-tickets-77532775619 | 2019-11-07T19:15:00Z | Thu, Nov 7, 11:15 AM-12:15 PM PST | Focused | |||
| PASS Summit | Rohan Kumar | Ariel Pisetzky | https://www.pass.org/summit/2018/Learn/Keynotes.aspx | 2018-11-07T08:15:00Z | 90 | Wed, Nov 7, 8:15-9:45 am | Mention | |
| 智能云 2019 | Rohan Kumar | Henning Rauch | 2019-04-09T09:00:00Z | 90 | 4 月 9 日星期二,上午 9:00-10:30 | Mention | ||
| Ignite 2019 | Jie Feng | https://myignite.techcommunity.microsoft.com/sessions/83940 |
100 | 2019-11-06T14:35:00Z | 20 | Wed, Nov 6, 9:35 AM - 9:55 AM | Mention | |
| Ignite 2019 | Bernhard Rode | 勒海当, 里卡多尼佩尔 | https://myignite.techcommunity.microsoft.com/sessions/81596 |
200 | 2019-11-06T16:45:00Z | 45 | Wed, Nov 6, 11:45 AM-12:30 PM | Mention |
| Ignite 2019 | Tzvia Gitlin | Troyna | https://myignite.techcommunity.microsoft.com/sessions/83933 |
400 | 2019-11-06T17:30:00Z | 75 | Wed, Nov 6, 12:30 PM-1:30 PM | Focused |
| Ignite 2019 | Jie Feng | Troyna | https://myignite.techcommunity.microsoft.com/sessions/81057 |
300 | 2019-11-06T20:30:00Z | 45 | Wed, Nov 6, 3:30 PM-4:15 PM | Mention |
| Ignite 2019 | Manoj Raheja | https://myignite.techcommunity.microsoft.com/sessions/83939 |
300 | 2019-11-07T18:15:00Z | 20 | Thu, Nov 7, 1:15 PM-1:35 PM | Focused | |
| Ignite 2019 | Uri Barash | https://myignite.techcommunity.microsoft.com/sessions/81060 |
300 | 2019-11-08T17:30:00Z | 45 | 星期五, 11 月 8 日,上午 10:30-11:15 | Focused | |
| Ignite 2018 | Manoj Raheja | https://free.blessedness.top/shows/ignite-2018/ |
200 | 20 | Focused | |||
| ... | ... | ... | ... | ... | ... | ... | ... | ... |
Related content
- To choose what columns from the input to keep in the output, use project-keep.
- 若要重命名列,请使用
project-rename。 - 若要对列重新排序,请使用
project-reorder。