## Random Number

Purpose

The Random Number masking format generates random integers within a specified range to replace column data.

Inputs

**Start Number:**The lower bound of the range within which the integers should be generated.**End Number:**The upper bound of the range within which the integers should be generated.

The inputs can be any integers, including negative integers. Start Number must be less than or equal to End Number. They should be valid for the column size.

Supported Data Types

- Character
- Numeric

Characteristics

- Combinable: Yes
- Deterministic: No
- Reversible: No
- Uniqueness: Yes. The number of distinct values in the specified range must be greater than or equal to the number of values in the column.

Example

Suppose you have an `EMPLOYEE_AGE`

column and you want to generate random ages from 21 through 65. You can use the Random Number masking format to generate random integers from 21 through 65, including those values.

The following table shows the original `EMPLOYEE_AGE`

column and the `MASKED_EMPLOYEE_AGE`

column.

EMPLOYEE_AGE | MASKED_EMPLOYEE_AGE |
---|---|

21 | 59 |

35 | 22 |

51 | 43 |

28 | 38 |

64 | 61 |

75 | 21 |