RAND() seed value not accepted

[DanBlenkinsop]

According to the function description, RAND() accepts one optional argument, a random seed integer:

https://help.alteryx.com/aac/en/trifacta-classic/wrangle-language/other-functions/rand-function.html...

However, when I enter anything in the brackets, e.g. RAND(1), I get a "wrong number of parameters" error.  Is this a bug, or am I missing something?

[alexnajm · Accepted solution]

This documentation is for Trifacta, not Designer Desktop 😊

[apathetichell]

Are you using Alteryx Desktop or Alteryx Cloud/Trifacta? That's Trifacta documentation. For Designer/Alteryx  Rand() doesn't except anything. RandINT does.

[CoG · Accepted solution]

That being said, are you trying to do something specific, there may be another way to control the seed for random process (depending on your use case). This is because the Random Sample Tool has a seed parameter that you can configure.

Hope this helps and Happy Solving!