Selecting one <Output Audience> per <Different Input Audience>
Select this option to choose exactly one output audience record for each input audience record (for example, to choose one email address per customer).
About this task
You must specify a business rule to indicate how the single entity should be selected (min/max/median of some field) or choose AnyOne (in this case, no field choices are available).
This option is available only if the input audience level is not normalized (that is, the record ID is not unique in the selected Choose Level table).
In addition to creating a query, the Based on criterion also supports keywords allowing the functional equivalent of a GROUPBY macro function to be performed.
Procedure
- Select an input source for Input and
an output audience for the Audience process.
The Select options become available.
- Select One <Output Audience Level> per <Input Audience Level>.
-
Select a value from the Based on drop-down list.
(Field selection, using the drop-down list to the right, becomes inactive when you select Any One. If this is your selection, skip to step 5.)
-
Select a field in the next drop-down list to which the Based on
function relates:
- (Optional) To filter records before performing the Based On computation, use Filter.
- Click OK.