Random with no repeat

josemaria_cabre — Sat, 16 Nov 2024 19:07:55 GMT

Hi ,

I'm trying to build this table, where random numbers (range between 1 and 7) are generated, but they must be unique within same row:

customer	num1	num2	num3
a	1	5	4
b	4	3	2
c	7	1	4
d	1	5	6
e	4	6	1
f	6	3	1

I'd like to assign these random numbers to 'customer' dimension of table 'customers'. How do I acchieve that in my script? Any help would be appreciated.

Best regards,
Jose.

Re: Random with no repeat

JordyWegman — Wed, 12 Feb 2020 11:54:39 GMT

Hi Jose,

How random should it be? Because you can get RowNo() and the sequential number would give an unique number for each row. You can subtract or add numbers to create different numbers.

Also you can resident load it in descending order and add another RowNo().

Another possibility is creating a rand() function, sort on this rand function and add RowNo().

All these possibilities give you unique numbers for each customer.

Jordy

Climber

topic Random with no repeat in App Development

Random with no repeat

Re: Random with no repeat