Set boolean repeating value

The Set boolean repeating value activity allows you to set a specific boolean value for repeating during package execution.

Usage

To use the Set boolean repeating value activity, it must be placed inside a table masking activity or a similar activity that iterates over data. Set the RepeaterId as the ID of the repeater you want to add values to. Next, change the property RepeaterKey by selecting the ... button to choose from which table record properties will the key be composed of, up to a maximum of five properties. This will dictate by what key the new repeating value will be saved in the repeaters database. Lastly, add the function which will get the value by setting the GetValueFunc property. This can be done by either using a lambda expression to get the value from the record (e.g. record => record.Value) or using custom code to calculate the value. Either way, the function must return a boolean value.

Figure 1: Property Selector window

Example

Let's assume that we are masking the Customer table and are masking the Gender column which can have either M or F as values. However, we know that we will mask genders in another table that also contains social security numbers, but the Gender column there is a boolean value (0 for female, 1 for male), so we want to set repeater values with social security numbers as keys and boolean values for gender as repeater values during masking of the Customer table.

First we place the Customer masking activity and put the Set boolean repeating value masking activity within it. Then we can set the RepeaterId property to the ID of the repeater we are using, which is "GenderRepeater" in our case. Next, we create the RepeatingKey by selecting the ... button to open the Property Selector window where we can select the SocialSecurityNumber property and click OK. Lastly, we add the lambda expression record => record.Gender == "M" as the GetValueFunc to create the desired repeater value for every record.

Figure 2: Setting a boolean repeating value during masking

Properties