topic Re: How to generate random numbers between 1-20 in App Development

How to generate random numbers between 1-20

techvarun — Tue, 30 Nov 2021 18:17:33 GMT

I want to generate 20 random numbers to be distributed within 100%.

I am using the below script but it is creating some duplicates. Please advice on getting the unique 20 records

Table:
LOAD
ROUND(rand()*20,1)AS User_Number,
'10' AS Percentage
AutoGenerate 2;

Concatenate(Table)
LOAD
ROUND(rand()*20,1)AS User_Number,
'15' AS Percentage

AutoGenerate 3;
Concatenate(Table)
LOAD
ROUND(rand()*20,1)AS User_Number,
'20' AS Percentage
AutoGenerate 4;

Concatenate(Table)
LOAD
ROUND(rand()*20,1)AS User_Number,
'25' AS Percentage
AutoGenerate 5;

Concatenate(Table)
LOAD
ROUND(rand()*20,1)AS User_Number,
'30' AS Percentage
AutoGenerate 6;

Thanks

Varun

Re: How to generate random numbers between 1-20

rubenmarin — Sat, 19 Jun 2021 07:46:33 GMT

Hi, you can create a table with enough records to ensure it has all numbers, and from this table load the ones that are different.

rand: LOAD ROUND((rand()*19)+1,1) as value Autogenerate 2000; UserCodes: LOAD value as UserCode, RowNo() as RowNumber resident rand Where not exists('UserCode',value); DROP Table rand;

Then you can use the Lookup() function to assing the values of this table:

Table: LOAD Lookup('UserCode', 'RowNumber', RowNo(), 'UserCodes') as User_Number, '10' AS Percentage AutoGenerate 2; Concatenate(Table) LOAD Lookup('UserCode', 'RowNumber', RowNo(), 'UserCodes') as User_Number, '15' AS Percentage AutoGenerate 3; ... DROP table UserCodes;

Re: How to generate random numbers between 1-20

techvarun — Sun, 20 Jun 2021 04:19:32 GMT

Thanks a lot.. it worked.