assigning random numbers for records

[Bharath]

Hi,

I have 80000 members (records). I have to assign them random between the age of 20 -65. how to do it in alteryx ? can anyone please help me with that ?

Thanks,

Bharath

[JoeM · Accepted solution]

Try using the following expression inside a formula tool: RandInt(45)+20

[MarqueeCrew]

I'll bite.  Why are you assigning them random ages?

[vishwa_0308 · Accepted solution]

please try this..

take a formula tool and make a column "age" then put formula randInt(65) which will create a random number ranges 0-65.

then again put below formula using same field/new field:

"if [age]<10 then [age]+20 elseif 

[age]>10 and [age]<=15 then [age]+10 elseif
[age]>15 then [age]+5 else [age] endif"

after this you will get random ages within 20-65.