Alteryx Designer Desktop Discussions

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

Random % Sample - How can I randomize the seed number to be different each time?

AndrewLantz01
5 - Atom

I have utilized a random sampling workflow to generate random samples of data I have input. However, I noticed that I am locked into only using a specified set seed number in my workflow -- Therefore, if I were to rerun it on the same data again I would receive the same sample as the first run of the workflow. 

 

Does anyone know of a way to insert a formula to randomize the "random seed" field for the deterministic output, so that I don't always end up with the same seed used if I rerun my workflow?

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@AndrewLantz01 
Maybe we can use Numeric up Down tool?

gawa
16 - Nebula
16 - Nebula

hi @AndrewLantz01 

Random Sample Tool will be first choice. Do not forget to uncheck option "Deterministic Output" to unlock random seed.

 

If you cannot use it for some reason, try other method with reference to my WF that uses Rand() function of Formula tools. Rand() returns double value between 0 and 1, and return the different value everytime you run. The attached workflows utilize its nature to get random sampling.

 

 

image.png

MarqueeCrew
20 - Arcturus
20 - Arcturus

@AndrewLantz01 

 

I'm a fan of creating a Random Field as rand() and then sitting on it.  Now I can choose to sample a number or percentage of records.  

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels
Top Solution Authors