Hello,
I trying to learn how to assign a person to a group ordered by ID number. Please see the example below for better clarity.
I have this dataset
The dataset will be split into 6 groups. Some of the members have already been assigned a group, but some have not. I want to assign the remaining members to groups so that each group has 5 members. I want to perform the assignment in order by ID number. For example, if group 1 needs two more member, assign the first two available member to that group (based on ID number). The same process would repeat for group 2, then group 3, etc
I would highly appreciate it if anyone can provide me with possible solutions to tackle this type of problem.
Hi @Maltaleb001
This question is very similar to the one asked here. That question is on the Alteryx Advanced exam. Posting any questions or answers for any Alteryx exams on the Community is prohibited.
Dan