Generate value between two values

This function generates a number randomly chosen between the user-defined minimum and maximum values.

Option	Description
Extra parameter	This function requires an extra parameter. The minimum and maximum values are specified as an extra parameter, by a comma-separated list of two integers, for example: `"1,10"`. If the user-defined minimum and maximum values do not use the right format, the function returns the following masked values: If the data type of the input column is String, the functions returns an empty string. If the data type of the input column is a numeric data type, the functions returns 0.

Option

Description

Extra parameter

This function requires an extra parameter.

The minimum and maximum values are specified as an extra parameter, by a comma-separated list of two integers, for example: "1,10".

If the user-defined minimum and maximum values do not use the right format, the function returns the following masked values:

If the data type of the input column is String, the functions returns an empty string.
If the data type of the input column is a numeric data type, the functions returns 0.

The masked value has been randomly selected within the minimum value (50) and the maximum value (99) defined as extra parameters.

Input value	Extra parameter	Example of a masked value
24	"50,99"	93

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!