There are 50 patients and 10 appointment slots. Each slot can hold a maximum of 5 patients.
E.g. If Appoint 1 has only 2 patients, I want to assignee the first 3 available patients to that slot and then move on to appoint 2.
I have tried to make an iterative flow but I couldn’t apply the logic to allow the first available patients to be assigned to the first appoint slots.
Solved! Go to Solution.
Hi @h12 ,
I approached this using the generate rows function to assign a slot to the person counting from 1 up and generating the number of rows according to the remaining spaces in the app slot (assuming 5).
I hope this helps.
M.
Thank you!
Also, could we get the full list of patient names OR IDs in the output, so it shows they have all been allocated to an appoint (currently shows only 28).
Is it possible to use iterative macros to solve this?
Hi @h12
Use a Union tool after final Join tool and union the J output with the F output of the initial filter tool.
Dan
Thank you!