How to assign group number

[Labhesh]

Hi all,

I wanted to assign group number to unaasigned volunteer. In each group their has to be 20 volunteer for eg- if group 1 need 8 member so out of avaiable volunteer first 8 should be in it and so on for another groups.

So, In total of 25 groups will be created in the end with 20 member each.

Column Name: Group Number-- > Where Unassigned group number and assigned number are avaiable.

[DanielvanLeuzen · Accepted solution]

Hi Labhesh,

Thanks for the interesting challenge. I attached what I think is the solution.

I checked first how many were missing for each group and used the generate rows tool to create rows with missing group numbers. I joined those to the data that didn't had a group yet and used the union tool for those that already had a group. 

Hope this will solve your problem

[Labhesh]

HI @DanielvanLeuzen 

Thank you..😃

[DanielvanLeuzen]

You are welcome. Glad to be able to help