-
Request
a trial -
Request
a demo -
Request
a quote
-
Request
a trial -
Request
a demo -
Request
a quote
Masking Number Rollup
Description
|
The Number Rollup data masking component obtains a sub-range of the values from the finite predefined range of numeric values and allows a user to map the sub-range into a specified numeric value. A default value is set for the numbers not mapped via ranges. In Custom Properties, you can add a new filter for Rollup ranges, which can be imported and exported.
|
Usage Instructions:
|
1. Configure a source that contains the column with numeric characters. The data in the column may also include any other character that will be treated as a separator. 
+
|
|
2. Drag and Drop Masking Number Rollup component, connect the source and the Masking Number Rollup component with the source's precedence constraint.
|
|
3. Now, the precedence constraint (the blue arrow) passes proper meta-data to the Masking Number Rollup component. If you click on the constraint, you will see: 
+
|
|
4. Now that the metadata for the Masking Number Rollup exists, and values are passed into the data masking component, please open the component editor: 
+
|
|
5. In the second tab, there are input columns. Please check-mark only one column, the one that you will be masking with Masking Number Rollup algorithm: 
+
|
|
6. This will create an extra column with the prefix “Masked_”. 
+
|
|
7. Create a connection manager for the destination and configure the source component for the destination. In the connection manager, in the tab “Mappings”, specify that you want the newly-created Field_Masked to be a field replacing the original value. For that, just click on the available input columns, choose the masked value, and map to the “Available Destination Columns” 
+
|
|
8. Now, all the configurations are complete for the valid values. You can run the package with the Masking Number Rollup component, and see the results of data masking: 
+
|
Go to Documentation
Data Masking Components: Number Rollup
Download Manual
