�۶���Ƶ

Select the new targeting dimension via the Change dimension field.

During dimension change, you can keep all elements or select those to be kept in output. In the following example, the max. number of duplicates is set to 2.

When you choose to keep only one record, a collection is displayed in the work schema: This collection represents all records that will not be targeted in the final result (since only one record is kept). Like all other collections, this one lets you calculate aggregates or recover information in columns.

For example, if you change the Customers dimension to the Recipients dimension, it will be possible to target customers of a specific store, while adding the number of purchases made.

If you choose not to keep all this information, you can configure the duplicate management mode.

The blue arrows enable you to define the duplicate processing priority.

In the example above, recipients will be deduplicated on their email address first, then on their account number if necessary.

The Result tab lets you add additional information.

For example, you can recover the county based on the zip code by using a Substring type function. To do this:

• Click the Add data… link and select Data linked to the filtering dimension.

  

  note note
  NOTE
  For information on creating and managing additional columns, refer to Add data.

• Select the previous targeting dimension (before axis switch) and select the Zip Code in the recipient’s Location sub-tree, then click Edit expression.

  

• Click Advanced selection and choose Edit the formula using an expression.

  

• Use the functions offered in the list and specify the calculation to be performed.

  

• Finally, enter the label of the column you have just created.

  

Execute the workflow to view the result of this configuration. Compare the data in the tables before and after the change dimension activity, and compare the structure of the workflow tables, as shown in the following examples: