project-away operator

Learn how to use the project-away operator to select columns from the input table to exclude from the output table.

Select what columns from the input table to exclude from the output table.

Syntax

T | project-away ColumnNameOrPattern [, …]

Parameters

Name	Type	Required	Description
T	`string`	✔️	The tabular input from which to remove columns.
ColumnNameOrPattern	`string`	✔️	One or more column names or column wildcard-patterns to be removed from the output.

Returns

A table with columns that weren’t named as arguments. Contains same number of rows as the input table.

Examples

The input table PopulationData has 2 columns: State and Population. Project-away the Population column and you’re left with a list of state names.

PopulationData
| project-away Population

Output

The following table shows only the first 10 results.

State
ALABAMA
ALASKA
ARIZONA
ARKANSAS
CALIFORNIA
COLORADO
CONNECTICUT
DELAWARE
DISTRICT OF COLUMBIA
FLORIDA
…

Project-away using a column name pattern

This query removes columns starting with the word “session”.

ConferenceSessions
| project-away session*

Output

The table shows only the first 10 results.

conference	owner	participants	URL	level	starttime	duration	time_and_duration	kusto_affinity
PASS Summit 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
Intelligent Cloud 2019	Rohan Kumar	Henning Rauch			2019-04-09T09:00:00Z	90	Tue, Apr 9, 9:00-10:30 AM	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	Le Hai Dang, Ricardo Niepel	`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	`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	Fri, Nov8, 10:30 AM-11:15 AM	Focused
Ignite 2018	Manoj Raheja		https://azure.microsoft.com/resources/videos/ignite-2018-azure-data-explorer-%E2%80%93-query-billions-of-records-in-seconds/	200		20		Focused
…	…	…	…	…	…	…	…	…

To choose what columns from the input to keep in the output, use project-keep.
To rename columns, use project-rename.
To reorder columns, use project-reorder.

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.