Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Allocation of work

beginner
6 - Meteoroid

Hello everyone!

I need help in creating a workflow for allocating accounts.
I have list of ticket numbers(which is unique) and multiple Request types.

Requirement is Each request type should be allocated to individuals as per Allocation sheet attached.
Attached sample data.

6 REPLIES 6
Dina
9 - Comet

Is this what you are looking for?

Dina_0-1685644550169.png

 

beginner
6 - Meteoroid

Thank you Dina for responding.

 

In this workflow same ticket is allocated to multiple individuals. What I need is tickets should be allocated to all the individuals equally 

 

OllieClarke
15 - Aurora
15 - Aurora

@beginner I think this is what you're after:

OllieClarke_0-1685721364795.png

OllieClarke_1-1685721386714.png

 

The join formula uses the mod function to assign each row to each person (and then the switch to make mod 0 the same as the total number of people)

 

Hope that helps,

 

Ollie

 

beginner
6 - Meteoroid

Hi Ollie,

 

Thank you for the below workflow.  What i am trying to achieving is little different from the below solution.

 

For example- The output i need is - If Request type = KYC and as per allocation sheet  KYC tickets should be allocated only between Jason, James and Paul, rest of the individuals should not be assigned with KYC ticket. Likewise same needs to be followed for other request types.

 

I have attached sample Output file, please check and assist on how i can get this using Alteryx.

 

Thank you!

OllieClarke
15 - Aurora
15 - Aurora

Ah @beginner apologies, now I understand. 

 

A little tweak to the workflow to use the multi-row formula to create a grouped recordID will get you there. I also included the (optional) randomisation of names as well

 

OllieClarke_0-1685958522759.png

 

beginner
6 - Meteoroid

Thank you Ollie, this is exactly what i was looking for.  Appreciate your help!

Labels