topic Re: Formula for creating random numbers in Alteryx Designer Desktop Discussions

Formula for creating random numbers

Bharath — Thu, 24 May 2018 01:39:12 GMT

I have to assign random numbers between 0.6 - 1 for 500000 records in alteryx. I tried by using function called Randint() but its not working. can anyone please help me on this.

Thanks,

Bharath

Re: Formula for creating random numbers

JohnJPS — Fri, 01 Apr 2016 18:35:56 GMT

Try Rand() instead of RandInt(); it will give you a real number between 0 and 1; then multiply (e.g. Rand() * 0.6 for your case should be very close to what you need)

Re: Formula for creating random numbers

MarqueeCrew — Fri, 01 Apr 2016 18:34:35 GMT

(RANDINT(4000)/10000)+.6

Re: Formula for creating random numbers

Bharath — Fri, 01 Apr 2016 18:49:21 GMT

Hi Marquee,

thank you for your reply. actually among the 500000 records some need to have 0.6, some should have 0.7, 0.8, 0.9 and 1 all these values should be randomly assigned for all the 50000 records.

Re: Formula for creating random numbers

Bharath — Fri, 01 Apr 2016 18:51:56 GMT

Acutally I am trying to crate a variable column with random values from 0.6 - 1.0. so some values should have 0.6 , some should have 0.7 and some should have 0.8,0.9 but i dont know how specify the interval from and to

Re: Formula for creating random numbers

MarqueeCrew — Fri, 01 Apr 2016 18:54:10 GMT

they should. I'm assigning values between 0 and 4,000 and then will be adding .6 to the product of the random number * .0001

this gets you random numbers between .6 and 1.

If you test this you should get min of .6 and max of 1 with avg of .8

Please do try it. I've got a sample module included with 500,000 records (generated).

Thanks,

Mark

Re: Formula for creating random numbers

JohnJPS — Fri, 01 Apr 2016 18:58:03 GMT

I think I understand; could you try

SWITCH(RandInt(4),1,
0,0.6,
1,0.7,
2,0.8,
3,0.9)

This will give only the distinct values 0.6, 0.7, 0.8, 0.9, and 1. ...

(edit: But @MarqueeCrew answer that follows is better.)

Re: Formula for creating random numbers

MarqueeCrew — Fri, 01 Apr 2016 18:55:54 GMT

if you only want {.6,.7,.8,.9,1} you can modify expression:

(RANDINT(4)/10)+.6

Re: Formula for creating random numbers

Bharath — Fri, 01 Apr 2016 19:33:26 GMT

Hi Marquee,

yes it works. thank you for helping me. but 0.9 value is not assigned while using htis formula. is there any specific reason for this ?

Thanks,

bharath

Re: Formula for creating random numbers

MarqueeCrew — Fri, 01 Apr 2016 19:38:21 GMT

I can only say RANDOM things happen. Here is a count from my test of 500,000 values.

rand	Count
.6	99,714
.7	100,117
.8	100,058
.9	99,881
1	100,230

Re: Formula for creating random numbers

Bharath — Fri, 01 Apr 2016 19:50:49 GMT

Hi Marquee,

Thank you for helping me.

Thanks,

Bharath