Randomize Date

Goal

Write randomize rule logic to

• Takes the original values of the type date, and adds random noise
• Specify the random noise by using the offset and flat-noise parameters (percentage-noise excluded)

Ano Structure and Example

Structure

        ...
        randomize <column> <rule-name>
            type date
            format %tF
            convert String2Date
            offset <offset>
            flat-noise <flat-noise>
        ...

Update Example

table BOOKING
    ...
    column date FROMDATE
    ...
...
task ... {
    update BOOKING
        randomize FROMDATE
            type date
            format %tF
            convert String2Date
            offset 300.0
            flat-noise 5.0
        ...
}

• type: date
• format: %tF - date format
• convert: String2Date - a built-in conversion function
• offset: A fixed (double) value, in number of days, that is added to the original value
• flat-noise: A fixed noise value, in number of days, that is multiplied with the random number r
  • large flat-noise: larger spread of generated values

Noise Formula

1. A random number r is drawn (at runtime) from the Standard Normal (Gaussian) Distribution Function
2. We use r, together with given noise parameters to add noise to the original value

Noise formula for date

original_value + offset + (flat-noise * r)