Allocation of data

Question

hi ,

I have this requirement of allocation of invoices to the team members . There 4 team members and invoices need to be allocated.

Let me say they are A,B,C,D and if the number of invoices equally divided among 4 then no problem .But if it is not the invoice remaining invoices  must be allocated beginnning from A as show below :

How this can be done in alteryx.

Scenario 1   Scenario 2      # of invoices 100 # of invoices 102A25 A26B25 B26C25 C25D25 D25

DataNath · Accepted Answer

Hey @praneshsapmm, how does this look? Let me know if you run into any issues when applying this - just need to bring your # of invoices alongside the records:

Uneven split:

Even split:

praneshsapmm · Accepted Answer

Hi @DataNath ,

That worked perfectly . Thanks .

Also i have another extension to below requirement . once the allocation is done based on the number of invoice allocation to user , name has to be populated against invoice line items . For ex : A is 26 invoice below , based on this info how can stamp A against each invoice line item 26 times.

Scenario 1   Scenario 2      # of invoices 100 # of invoices 102A25 A26B25 B26C25 C25D25 D25     Invoice1A   Invoice2A   Invoice3A   Invoice4A   Invoice5A   Invoice6A   Invoice7A   Invoice8A