distinct operator
Learn how to use the distinct operator to create a table with the distinct combination of the columns of the input table.
Produces a table with the distinct combination of the provided columns of the input table.
Syntax
T | distinct ColumnName[,ColumnName2, ...]
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| ColumnName | string | ✔️ | The column name to search for distinct values. |
Example
Shows distinct combination of states and type of events that led to over 45 direct injuries.
StormEvents
| where InjuriesDirect > 45
| distinct State, EventType
Output
| State | EventType |
|---|---|
| TEXAS | Winter Weather |
| KANSAS | Tornado |
| MISSOURI | Excessive Heat |
| OKLAHOMA | Thunderstorm Wind |
| OKLAHOMA | Excessive Heat |
| ALABAMA | Tornado |
| ALABAMA | Heat |
| TENNESSEE | Heat |
| CALIFORNIA | Wildfire |
Related content
If the group by keys are of high cardinalities, try summarize by ... with the shuffle strategy.
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.