Tabular OperatorsProject Operators

project-away

Selects all columns from the input except the specified columns.

Syntax

project-away column, ...

Remove specified columns from output

Parameters

Name	Description
column	Column name to exclude from output

Examples

Example 1 — Remove a single column

datatable(warrior:string, voyages:long, weapon:string, clan:string)[
  "Ragnar", 42, "axe", "Lothbrok",
  "Bjorn", 31, "sword", "Lothbrok"
]
| project-away clan

warrior (string)	voyages (long)	weapon (string)
Bjorn	31	sword
Ragnar	42	axe

Example 2 — Remove multiple columns

datatable(warrior:string, voyages:long, weapon:string, clan:string)[
  "Ragnar", 42, "axe", "Lothbrok",
  "Bjorn", 31, "sword", "Lothbrok"
]
| project-away voyages, clan

warrior (string)	weapon (string)
Bjorn	sword
Ragnar	axe

project

Selects specific columns from the input and optionally computes new columns or renames existing ones.

count

Returns the number of rows in the input table as a single row with a single column named Count.

On this page

Syntax Parameters Examples Example 1 — Remove a single column Example 2 — Remove multiple columns Related