Use the group-unique directive to create unique rows based on column criteria.
pebblestream:group-unique("Last name", "First name", ...)
All rows with the same "Last name" and "First name" are condensed to one, and only columns "Last name" and "First name" are included.
Can't be used with group, group-sum, or group-ratio.
group-unique is deprecated in all releases after v1. Use the group directive instead.
Consider the worksheet Transactions, which consists of customers' names and transaction dates.
the following code snippet will compute the set of unique names and place it in the Names worksheet.
pebblestream:from(Transactions) pebblestream:group-unique("Last", "First")
Here is the result.
Updated over 1 year ago