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
Solved! Go to 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!
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
Thanks, the solution worked for me.