Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

RAND() seed value not accepted

DanBlenkinsop
5 - Atom

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?

3 REPLIES 3
alexnajm
17 - Castor
17 - Castor

This documentation is for Trifacta, not Designer Desktop 😊

apathetichell
19 - Altair

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

CoG
14 - Magnetar

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!

Labels
Top Solution Authors