Returns the first value for the specified field.
Use first() to return the first value of a measure or dimension. You can also use first() used to return the value of a field without grouping by that field.
note: If the values are not sorted, the 'first' value could be any value in the tuple.
Example - Return the First Industry for an Account Owner
Your reps own opportunities in several industries. You need a list of rep names with their first industry, where industry is sorted alphabetically. Group by account owner and industry, sort by industry, then use first() to get the first industry.
q = load "DTC_Opportunity_SAMPLE";
q = group q by ('Account_Owner', 'Industry');
q = foreach q generate 'Account_Owner' as 'Account_Owner', 'Industry' as 'Industry';
q = order q by 'Industry';
q = foreach q generate 'Account_Owner' as 'Account_Owner', first('Industry') as 'One Industry';
Example - Return Any Industry for an Account Owner
Your reps own opportunities in several industries. You need a list of rep names with any one of a rep's industry - it doesn't matter which one. In this case. Group by account owner then use first() to get the first industry from an unsorted collection.
q = load "DTC_Opportunity_SAMPLE";
q = group q by 'Account_Owner';
q = foreach q generate 'Account_Owner' as 'Account_Owner', first('Industry') as 'One Industry';
The resulting table displays each rep along with one of their industries (basically the first industry from an unsorted collection).
See Also