Allocating values until its full/complete

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

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.

query - Copy.xlsx

Iterative Macro

Accepted answers

mceleavey

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.

solution.yxmd

All comments

mceleavey

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.

solution.yxmd

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703