There are different ways to scramble the date, depending on different factors.

  1. Type of data
  2. Security rating
  3. 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.


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment