Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Random Group From List

Sidey1978
8 - Asteroid

Happy new year all!

 

I don't seem to have my brain switched on just yet after all the holiday fun!

 

I'm trying to create a workflow that will select one person from each team at random. I've been trying the Rand function and the sample tool, but so far haven't managed to achieve the correct result. 

 

I'm sure this is quite simple, but I just can't get my head around it. I've attached some dummy data. It would be great if someone could point me in the right direction.

 

Thanks!

5 REPLIES 5
MarqueeCrew
20 - Arcturus
20 - Arcturus

1. Create a random field rand()

2. Sort by random field

3.  Sample 1 record

 

 cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
OliverW
Alteryx Alumni (Retired)

Hi @Sidey1978 ,

 

would the attached work for you?

 

Best wishes

Olli

OliverW
Alteryx Alumni (Retired)

@MarqueeCrew beat me to it, I had created and posted it, while he had written his explanation 🙂

Sidey1978
8 - Asteroid

Thanks Mark, that's sorted it!

Sidey1978
8 - Asteroid

Thanks for looking at this too @OliverW . So many helpful people on here!

 

Much appreciated!

Labels