There are different ways to scramble the date, depending on different factors.
- Type of data
- Security rating
- Variability of data
You can apply either:
- Hard Coded
The requirement for making a file a single value is the most basic form of scrambling. This will overwrite the existing contents with the value entered here.
- Lookup List
The lookup list, as described in the prerequisites, is for selecting a Scramble field from a predetermined list. This is often used on names, where a sensible but randomised value is required.
- Custom Function Module
If more complicated transformations are necessary then a custom function module can be called.
The parameters for the function module are:
Sample source code for a Custom Function is given:
Source Code Example
- Random Date
The random date option will take the original date and apply a transformation of a random date within the range given.
- Random Number
User for when unique numbers need to be randomised.
A range can be supplied.
The scramble of the number can be applied to the last __n numbers by using the field give.
- Random Multiplier
Often used for value, price or salary fields where the contents needs to be kept within given boundaries.
- Derived Field
A derived field uses the contents of two other field to give the result of the one selected. You can use concatenation, apply CASE masking and offsets.
Dervide fields should be used at the end of a list of Scramble Rules to ensure all source fields have been processed.
All Scramble Rules can make use of basic WHERE clauses to apply a field transformation.
Example WHERE might look like: “GESCH = ‘1’”
This means that where Scramble GT finds field GESCH with a content of “1” then a transformation is applied.