unique

DefinitionCopy Anchor Link

Return a new table with all unique combination of values in the specified dimensions. It is similar to group but without the need to specify a source table. The difference is that group will only return combination of values that exist with respect to the source table, while unique will choose the source table with the most number of rows.

Syntax

unique(dimension, dimension, ...)

unique(orders.id, products.id) // -> Table(orders.id, products.id)

unique(orders.id, products.id, customers.id) // -> Table(orders.id, products.id, customers.id)

Input

• dimension (repeatable): A fully-qualified reference to a dimension. The output table will have one row for each unique combination of values in the specified dimensions.

Output

A new table with one row for each unique combination of values in the specified dimensions.

Sample UsagesCopy Anchor Link

unique(orders.id, products.id)

Using unique with select just like group:

unique(products.name) | select(products.name, count(products.id))

See alsoCopy Anchor Link

• group()
• select()
• Pipe operator