experimental.distinct() function

The experimental.distinct() function returns unique values from the _value column. The _value of each output record is set to a distinct value in the specified column. null is considered a distinct value.

Function type: Selector

import "experimental"

experimental.distinct()

Output schema

experimental.distinct() outputs a single table for each input table and does the following:

• Outputs a single record for each distinct value.
• Drops all columns not in the group key.

Parameters

tables

Input data. Default is pipe-forwarded data.

Examples

Return distinct values for each input table

import "experimental"

data
	|> experimental.distinct()