Question on RAND()

[tww]

Hi all,

I am wondering if there is a way to generate "fixed" random numbers, i.e. to generate every time when the workflow runs.

In Excel, I used to copy the "random values" to a new column. I am wondering if I could achieve similar results in Alteryx.

rand	fixed rand
0.453125	0.007403
0.672931	0.959654
0.827062	0.450144
0.68392	0.436166
0.783692	0.882208
0.444155	0.487301
0.757795	0.207235
0.953057	0.649728
0.040092	0.337433
0.300416	0.861588
0.376649	0.642034
0.420323	0.995746
0.151951	0.034265
0.090708	0.4749
0.596626	0.362383
0.501849	0.250315
0.18455	0.857742
0.682799	0.81214
0.210958	0.166386
0.376681	0.512042
0.829143	0.398639
0.593593	0.016372
0.808895	0.296618

[FinnCharlton]

Hi @tww , one way to do this is to use the random sample tool, and use the 'Deterministic Output' option:

Here I use the generate rows tool to generate a load of decimals, then take a "random" sample using the deterministic output. Every time the workflow is run, it will choose the same numbers. Hope this helps!

[tww]

Hi @FinnCharlton Thank you for the suggestion.