Equally assign a random number to a record

Question

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

tf05 · Answer

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

Qiu · Answer

@tf05 
Can you give some sample input and output?