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
Page 1 / 1
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.
Hello, thank you for the quick answer!
How can I use these vertica functionalities in my analysis?
Not directly in an Analysis, but you can access vertica functions in data integration, through data jobs.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.