Random Number

Options

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.

**If this answer solved your problem be sure to like it and accept it as a solution!

Best Answer

  • david_cunningham
    edited May 7 Answer ✓
    Options

    @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

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

Answers

  • david_cunningham
    Options

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

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • Ashleigh
    Ashleigh Coach
    Options

    @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.

    **If this answer solved your problem be sure to like it and accept it as a solution!

  • david_cunningham
    edited May 7 Answer ✓
    Options

    @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

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • Ashleigh
    Ashleigh Coach
    Options

    @david_cunningham that worked perfectly, thank you!!

    **If this answer solved your problem be sure to like it and accept it as a solution!