Specifying the value option

The Value option and corresponding fields control the output of the scrambling process.

The way in which you select, or specify, this option differs according to whether the associated column is alphanumeric or numeric:
  • For alphanumeric column, do one of these:
    • Deselect the Value option by entering a blank.
    • Select the Value option by entering a "/".
  • For numeric columns, do one of these:
    • Deselect the Value option by entering a blank.
    • Select a range by entering "1".
    • Select the Value option by entering "2".

Value option selected ("/")

Selecting this option allows you to provide:
  • A translate data set. This applies when you select Scramble Type 3 ("Translate") with input and output columns and a value data set.
  • A lookup data set. This applies when you select a Scramble Type of 1 ("Random") or 2 ("Repeatable") along with a value data set name. The data set is loaded into memory and the output value is randomly or repeatably selected from one of the loaded records. The output column determines the location of the value that is selected for this column.
  • A value list. This applies when you select a Scramble Type of 1 ("Random") or 2 ("Repeatable") without a value data set name and allows you to enter the selection values for this column on the panel displayed when you press Enter. One of the values you provide is randomly or repeatably selected during a copy, import, or export operation. The values you enter are stored in the template. Value lists are described in more detail later.

Value option deselected (blank)

Deselecting this option scrambles the input column to produce a random or repeatable output value. Scramble Type must be set to 1 ("Random") or 2 ("Repeatable").