Allocation of groups

Question

Hi All!

I am trying to update the existing column based ob some condition.

This is the input data :

Groupclassroll_noaaa1 b2aac3 d4 e5aaf6 g7ach8aai9acj10ack11acl12acm13acn14 o15 p16acq17acr18aas19 t20 u21 v22 w23 x24

countgroup5aa8ac

What I'm trying to get in the output is if the count of group is less than 9 , I'll assign the unassigned roll_no in ascending order to those groups.

This is how the output be like:

Groupclassroll_noaaa1aab2aac3aad4aae5aaf6aag7ach8aai9acj10ack11acl12acm13acn14aao15acp16acq17acr18 s19 t20 u21 v22 w23 x24

As I'm still a new learner ,this solution would be of great help ,Thanks in advance 🙂

Qiu · Answer

@QurrathAmeena

Something does not add up to me yet.

Anyway, I interpret less than 9 meaning only 9 count can be assigned from top, so only 4 ac can be assigned.

0215-QurrathAmeena.yxmd

QurrathAmeena · Answer

@Qiu 
Hi,
Thanks for pointing that out, I have corrected the output what I want , 
Also, I'm trying to first assign based on roll_no.

For example : if roll_no 20 is not assigned roll_no 21 cannot be assigned .

The count of groups should not be more than 9,the unassigned ones are hence left blank.

Qiu · Answer

@QurrathAmeena

2 questions

* It seems you assigned 8 aa, which your 2nd table says 5
* why the last RollNo#24 is not getting assigned?