The Generate decimal number in range masking activity allows you to generate a random decimal number, with selected decimal digits, in the selected range.
|Table of contents
To use the Generate decimal number in range 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 mask. Generating a decimal number in a specific range requires you to enter the start and end numbers of the range and assign digits for the decimal part.
In this example we want to generate a random decimal number from the 'Amount' column in the Transactions table. The Generate decimal number in range is perfect for this situation.
First we place the Transactions activity into opened Package.xaml and put the Generate decimal number in range masking activity within it. Once placed, we select the Amount property that we want to mask with generated decimal numbers. We enter
-0.01 as the numbers used for range generation so that every generated decimal number is less than zero (a negative number). There is also a possibility to assigne the Number of decimal digits. We leave other properties as they are.
Figure 1: Generating decimal numbers in a specific range
|The property to mask.
x => x.Amount or choose property from the dropdown list
|If true, random selection should select unique values.
|Maximal number to generate.
|Minimal number to generate.
|Expression used for filtering records - only filtered items will be masked.
x => x.Amount.IsBetween(-15000, -0.01)
|If true, default values will be omitted in masking (i.e. null values are not masked).
|The ID of the repeater that will be used to detect repeating and save results when masking item key repeats.
|Key to use for repeating detection.
x => CompositeKey.Create(x.Amount) or choose properties from the pop-up window
|Display name of the activity in the workflow.
Generate decimal number in range
|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.