Randomly select perticular number of rows per employee

[nkrupabd]

HI ,

I have multiple Tickets per employee .

example employee A has 6 Tickets under him

               employee B has 100 tickets

               employee C has 2 ticket and So on

So is there a way where I can randomly pick 2 or 3 Tickets per employee.

Thank you.

[Qiu]

@nkrupabd 
We do have this Random 1 of N in the Sample tool. I think we can use it.

[Emmanuel_G]

@nkrupabd 

Find in attachement the way of doing that.

Step 1 : I generate random numbers for each line.

Step 2 : I sort them and then I pick the last 3 rows ( You can also take the first 3 ).

Let me know if there is and issue and do not hesitate to mark this answer as solution if it helped. 🙂