Random Number

Ashleigh

What is the best way to try and generate a random number in a Beast Mode? I am doing a presentation and want to remove names from my column and just make a beast mode to assign a random number. I tried doing rand() but that was not unique. I also tried doing length of name * rand() but that was also somehow not unique.

david_cunningham

@Ashleigh in that case, what if you did something with DENSE_RANK()?

DENSE_RANK() over (order by SUM(value) desc)

You could then do something like this

CONCAT('Customer ',DENSE_RANK() over (order by SUM(value) desc))

david_cunningham

Are you wanting it to be non-repeating overall, or non-repeating where each name is the same random number?

Ashleigh

@david_cunningham I am aggregating the values for each name so I need each name to have its own random number. Otherwise it tries to aggregate across multiple names.

david_cunningham

@Ashleigh in that case, what if you did something with DENSE_RANK()?

DENSE_RANK() over (order by SUM(value) desc)

You could then do something like this

CONCAT('Customer ',DENSE_RANK() over (order by SUM(value) desc))

Ashleigh

@david_cunningham that worked perfectly, thank you!!