Free Trial

Alteryx Designer Desktop Discussions

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

Random Assignment

ANARK
7 - Meteor

Hi there - I have list of orders to be analyzed by reps and need to randomly assign reps. The number of orders and the available reps are not the same everyday. Based on the total orders and number of reps, need to spit equally. Same order number will get repeated in the list as well, it should have single reviewer for the day.

 

Table1:

Order.NosRep
1 
2 
3 
4 
5 
6 
7 
1 
3 

 

Table2:

Rep
AB
BC

 

Expected Result:

Order.NosRep
1AB
2AB
3AB
4AB
5BC
6BC
7BC
1AB
3AB

 

Any suggestions?

3 REPLIES 3
MelGibson
10 - Fireball

The below should work as a quick solution. The one thing that would have to be updated would be the number reps in the tile tool if that changes. rep.png

 

Qiu
21 - Polaris
21 - Polaris

@ANARK 
Since you mentioned the Random, the flow get a bit larger.

1128-ANARK.png

ANARK
7 - Meteor

Thanks MelGibson,  Could you share the workflow ?

Labels
Top Solution Authors