Skip Navigation

Newer Version Available

This content describes an older version of this product. View Latest

unique()

Returns the count of unique values.

Example - Count the Number of Industries

Use unique() to count the number of different industries that you have opportunities with.

1q = load "DTC_Opportunity_SAMPLE";
2q = group q by all;
3q = foreach q generate unique('Industry') as 'unique_Industry';