The Pick DE last name from list masking activity allows you to mask table columns by replacing them with a value from the last name picklists belonging to Germany.
This masking activity is functionally identical to the Pick last name from list masking activity, but automatically chooses Germany as the country to pick last names for.
Table of contents |
---|
Usage |
Example |
Properties |
To use the Pick DE last name from list masking activity, it must be placed inside a table masking activity or a similar activity that iterates over data. Once placed, you can choose the property you want to mask, and then select the type of data you want to replace it with. Furthermore, you can specify what subset of picklist data will be used to get the replacement values from.
Let's assume we want to mask last names in the Customers table with ones from Germany. We can do this by first placing the Customer masking activity, and then placing the Pick DE last name from list masking activity inside it. Then, we choose the LastName column, and for the type of data to replace it with, we choose LastName. We leave the picklist declaration as it is.
Figure 1: German last name masking
Property group | Property name | Description | Example |
---|---|---|---|
Input properties | DataItemProperty | The property to mask. | Write x => x.LastName or choose property from the dropdown list |
EnforceUnique | If true, random selection should select unique values. | true or false |
|
Input: Filter | Filter | Expression used for filtering records - only filtered items will be masked. | x => x.LastName.StartsWith("E") |
SkipDefaultValues | If true, default values will be omitted in masking (i.e. null values are not masked). | true or false |
|
Input: Lookup | LookupItems | Items to use for random selection of parameters during masking. | PickLists.WorldLastNames.OnlyCountry("DE") |
LookupProperty | Lookup item property whose value should be used as replacement value. | lookup => lookup.LastName |
|
Input: Repeating | RepeaterId | The ID of the repeater that will be used to detect repeating and save results when masking item key repeats. | LastNameRepeater |
RepeatingKey | Key to use for repeating detection. | Write x => CompositeKey.Create(x.LastName, x.FirstName) or choose properties from the pop-up window |
|
RepeatValueOnly | Whether repeaters should only save the used lookup value, and not entire lookup item. | true or false |
|
Misc | DisplayName | Display name of the activity in the workflow. | Pick DE last name from list |
Result | Contains the masking definition object. It's a part of the masking infrastructure and should be ignored. | - |
BizDataX Documentation © Built by Ekobit. All rights reserved.
https://www.ekobit.com/ https://bizdatax.com/ https://bizdatax.com/support/