I have two Data sets 1.operator Name 2.Xlx1000 file. I need to allocate the volumes to everyone equally which is mentioned to "BB"
To which "RM" the operator is assigned, Also if Sam is getting 30 volumes then he should get dedicated RM to process. If "RM" Angel has 20 volumes then he should get 10 volumes of Angelyn. Likewise it should be assigned.
Please help me in this.
Correct format:
| RM Name | Gender | Country | Age | Date | Id | Segment | operator |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Sam |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Sam |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Sam |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Sam |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Sam |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Sam |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Sam |
Wrong format:
| RM Name | Gender | Country | Age | Date | Id | Segment | operator |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Sam |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Abi |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Pavithra |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Dominic |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Sathya |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Srinivas |
| Angel | Male | France | 24 | 15/10/2017 | 3259 | BB | Riya |