count operator
Learn how to use the count operator to return the number of records in the input record set.
Returns the number of records in the input record set.
Syntax
T | count
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| T | string | ✔️ | The tabular input whose records are to be counted. |
Returns
This function returns a table with a single record and column of type
long. The value of the only cell is the number of records in T.
Example
When you use the count operator with a table name, like StormEvents, it will return the total number of records in that table.
StormEvents | count
Output
| Count |
|---|
| 59066 |
Related content
For information about the count() aggregation function, see count() (aggregation function).
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.