Tabular Operators

distinct operator

Produces a table with the distinct combination of the provided Fields of the input table.

Syntax

| distinct Field1, Field2

Arguments

nametypedescription
Column Name(Field Name) The name of the field to add or updatestringColumn Name can be the field of your dataset, they are automatically generated for you and a list of field names can be specified in parentheses.

Example

Shows the distinct combination of geo.city, method, is_tls, and req_duration_ms.

['http-logs']
| distinct ['geo.city'], method, is_tls, req_duration_ms