Generate value between two values - 7.3

Data privacy
Version
7.3
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Data privacy components
Data Quality and Preparation > Third-party systems > Data Quality components > Data privacy components
Design and Development > Third-party systems > Data Quality components > Data privacy components
Last publication date
2024-04-03
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.

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