Clear value

The Clear value masking activity assigns the default empty value to a specified column of all table records.

Table of contents
Usage
Example
Properties

Usage

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.

Example

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.

Clear value example Figure 1: Clearing values

Properties

Property group	Property name	Description	Example
Input properties	DataItemProperty	The property to mask.	Write `x => x.Amount` or choose property from the dropdown list
Input: Filter	Filter	Expression used for filtering records - only filtered items will be masked.	`x => x.Amount != null`
	SkipDefaultValues	If true, default values will be omitted in masking (i.e. null values are not masked).	`true` or `false`
Misc	DisplayName	Display name of the activity in the workflow.	`Clear value`
	Result	Contains the masking definition object. It's a part of the masking infrastructure and should be ignored.	-