Hello, In the analysis view, I would like to multiply a set of values with a random operator similar to RAND() in excel however I cannot find anything like this in the documentation.
Does anyone know if there is such an operator ?
Thank you
Question
RANDOM operator
Hey Rodrigo,
Indeed in the PQL library there is no RANDOM functionality. I'm not sure what your use case is for this, but you could look into the RANDOM() and RANDOMINT() functionalities of vertica which are supported (Supported Vertica functions (celonis.com)). You can add a column or table to your data model for example through the data transformations as a workaround.
Not directly in an Analysis, but you can access vertica functions in data integration, through data jobs.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.