Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Equally assign a random number to a record

tf05
7 - Meteor

I have 4 advisors who need to be assigned new leads equally then they come in. The workflow is set to run every hour so the number of leads that need assigning varies. For example, it could 1 lead that needs assigning or it could be 10. 

 

The workflow I have set up uses the Tile tool which equally splits the records. This is fine then there is 4 or more as it is split equally. The problem I have is that more often than not, only 1 lead comes in at any one time. This is then always assigned to position 1 in the Tile tool.

 

I have explored using RandInt formula however when there is more than 1 lead it is not equally assigning them. For example, I could have 10 leads come in and one of the advisors receive none of them.

 

Does anyone have any ideas of how to get around this issue?

 

Thanks

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@tf05 
Can you give some sample input and output?

tf05
7 - Meteor

The input changes every time to workflow is run, so generally a number of new leads enter the workflow which then need to equally and randomly assigned to advisors on the output:

 

When only 1 lead is inputted I just need a random advisor out of the 4 to be assigned it (taking into account this will never be equally over a number of runs)

 

irst run:

Input:

Lead 1

Output:

Advisor 2 assigned Lead 1

 

Second Run:

Input:

Lead 1

Output:

Advisor 4 assigned Lead 1

 

Third Run

Input:

Lead 1

Lead 2

Lead 3 

Lead 4

Lead 5

Lead 6

 

Output:

All lead randomly assigned:

Advisor 1 assigned Leads 1 & 5

Advisor 2 assigned Leads 2 & 6

Advisor 3 assigned Lead 3

Advisor 4 assigned Lead 4

Labels
Top Solution Authors