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 |
Your ask isn't very clear... can you clarify further. In addition, what are you doing with this information / what have you tried?
I am a beginner in Alteryx, I am trying to allocate data to operator equally.