GROUPANY

Owned by Charles Bishop (Deactivated)
Jan 30, 2018

Syntax

GROUPANY(<any>)

Description

Returns an arbitrarily selected value contained in the group. The selection process is not completely random, but you can't influence which value is selected. This function used to be called GROUPFIRST and has been renamed GROUPANY in version 1.4.

This is an aggregate function. 

Example

Given the following data:

Customer_NameItem
2535JonZamioculcas
2888MikeSpider Lily
2535JonDatura
2535JonDahlia
5788JonSnapdragon
2888MikeMarguerite
2535JonWindflower
2888MikeElephant's Ear
2535JonChinese Evergreen
5788JonBegonia
5788JonStarfish Plant
2535JonHare's Foot Fern
2535JonVenus Flytrap
3545MoniqueRed Flame Ivy

First create a group, e.g. GROUPBY(#RawData!Customer_).

Customer_
2535
2888
3545
5788

Then use GROUPANY(#RawData!Item), and an arbitrary value from that column appears.

Customer_GROUPANY returns
2535Zamioculcas
2888Spider Lily
3545Red Flame Ivy
5788Snapdragon