The Clear value masking activity assigns the default empty value to a specified column of all table records.
|Table of contents|
To use the Clear value masking activity, it must be placed inside a table masking activity or a similar activity that iterates over data. Once placed, select the property you want to clear. This masking activity is most often used when you don't need masked values for testing purposes, but the column still contains sensitive data which can then just be set to its default value.
In this example we want to clear all values from the Amount column of the Transaction table since we don't need it for testing, but it still contains sensitive data. First we place the Transaction masking activity and put the Clear value masking activity within it. Next, we choose the Amount property that we want to clear. We leave other properties as they are.
Figure 1: Clearing values
|Property group||Property name||Description||Example|
|Input properties||DataItemProperty||The property to mask.||Write
|Input: Filter||Filter||Expression used for filtering records - only filtered items will be masked.||
|SkipDefaultValues||If true, default values will be omitted in masking (i.e. null values are not masked).||
|Misc||DisplayName||Display name of the activity in the workflow.||
|Result||Contains the masking definition object. It's a part of the masking infrastructure and should be ignored.||-|