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).

You must specify a business rule to indicate how the single entity should be selected (min/max/median of some field) or choose Any One (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 Oncriterion also supports keywords allowing the functional equivalent of a GROUPBY macro function to be performed.

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:

Click in the Based On text box.

The Select Field window appears. All fields from the table selected in the Choose Audience drop-down list appear, including any mapped dimension tables.

You can expand a table by clicking the "+" sign. Created derived fields are listed at the bottom.

Select a field and click OK.

(Optional) Create derived fields by clicking Derived Fields.

(Optional) To filter records before performing the Based On computation, use Filter.

Click OK.