Assign repeating value

The Assign repeating value activity allows you to manually create repeater values during masking.

When selecting a column that is a Foreign key, the repeating icon will automatically be displayed and the RepeaterId and RepeaterKey will be performed automatically.

It is often used in cases where you want to replace specific values in your database with custom values.

Usage

To use the Assign repeating value activity, place it anywhere in your workflow. Set the RepeaterId as the ID of the repeater you want to add values to. Next, change the property RepeaterKey by creating a CompositeKey with the following syntax:

CompositeKey.Create(parameter1, parameter2, ...)

You can add up to five parameters of different types. This will dictate by what key the new repeating value will be saved in the repeaters' database. Lastly, add the value itself by setting the RepeaterValue property.

Example

Let's assume that we are masking the Customer table and are using repeaters during first name masking. The Pick first name from list masking activity is picking values and saving them to the repeater database when necessary, but we want the name "James" to always be replaced with "John" instead of the masking activity picking its own replacement value. We can do that by placing the Assign repeating value activity before the Customer masking activity in the workflow.

Figure 1: Adding a new repeater value before masking

Now we have to set the properties of the activity. RepeaterId is set to the name of the repeater we are saving the first name which is in this case "FirstNameRepeater". We can create a new RepeaterKey by using the name we want to replace in future maskings, so in this case, we can set it to the following:

CompositeKey.Create("James")

Lastly, we set the RepeaterValue property as the name we want James to be replaced with, in this case, John. After the masking is completed, every first name James will be replaced with the value "John".

Figure 2: Assign repeating value properties

Properties