Allocating values until its full/complete

[h12]

There are 50 patients and 10 appointment slots. Each slot can hold a maximum of 5 patients.

1. I would like to assignee the patients that don’t have an appoint to an appoint slot starting with appointment slot 1 and working my way down to slot 10.

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.

[mceleavey · Accepted 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.

[h12]

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?

[danilang]

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 

[h12]

Thank you!