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
I can only say RANDOM things happen. Here is a count from my test of 500,000 values.
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)
(RANDINT(4000)/10000)+.6
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
