How to assign n no.of people to a list of records equally

[toxicboy]

Hi All,

I have a user details where name of users are provided and the numbers of user can change time to time. I need to assign them almost equally to a list of records.

Ex:

User

John

Matt

Stacy

Angie

Chris

And data records are like:

id	process_date	Priority
1	24-Jan-24	P1
2	11-Jan-24	P1
3	2-Feb-24	P2
4	24-Mar-23	P2
5	19-Sep-22	P3
6	09-Mar-23	P1
7	11-Aug-23	P3
8	24-Mar-23	P2
9	11-Jan-24	P1

I want to assign the 5 names equally to the above list, as below.

id	process_date	Priority	Assignee
1	24-Jan-24	P1	John
2	11-Jan-24	P1	Matt
3	2-Feb-24	P2	Stacy
4	24-Mar-23	P2	Angie
5	19-Sep-22	P3	Chris
6	09-Mar-23	P1	John
7	11-Aug-23	P3	Matt
8	24-Mar-23	P2	Stacy
9	11-Jan-24	P1	Angie

Appreciate your help in advance

[caltang · Accepted solution]

Something like this?

[DataNath · Accepted solution]

Hey @toxicboy, how's something like this? To explain the workflow we:

1) Get the count of records, and count of users

2) Append these so we can divide one by the other and take the ceiling value as the # of rows of the user list we need to generate

3) Generate these additional user rows and then re-split them into rows

4) Join with the starting records based on record position

Hope this helps!

[aatalai]

You could use a count record tool from the number of users and then plug that into a macro with the tile tool and use the count number of records to update the grouping

[toxicboy]

Thanks, the solution worked for me.