distinct

Learn how to produce a table with the distinct combination of the provided fields of your dataset.

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

Syntax

| distinct Field1, Field2

Run in Playground

Arguments

name	type	description
Column Name(Field Name) The name of the field to add or update	string	Column 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

Run in Playground