Random names considering percentage

[vmanika8]

Hello All,

I have a data set as per attached excel, i need to allocate people name to the "blank" items based on Region/percentage given against each person.(in text tool). :let me know the possible way to do that. Thank you.

[ShankerV]

Hi @vmanika8 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @vmanika8 

Step 1: Input

Step 2:

Step 3: 

Step 4:

Many thanks

Shanker V

[FinnCharlton]

Hi @vmanika8 , here's a way to do this that retains your initial count of Regions:

The method is the same as @ShankerV , but we add in a step to check that the count has been maintained. If it hasn't, the leftover row is assigned to the person with the highest percentage.

Hope this helps!

[ShankerV · Accepted solution]

Hi @vmanika8 

Step 5: 

Step 6:

Step 7:

Many thanks

Shanker V

[vmanika8]

Thanks for your workflow @FinnCharlton    

however, your workflow has decimal issue when we have odd number to multiply with percentage it is leaving remaining items open.

[vmanika8]

Hello @ShankerV  Can you pls upload your workflow. Let me check your flow as well?

[vmanika8]

I have one more requirement to the existing request. Now the data looks in this way with record ID which enable me to link this particular data with the original one. Can we do this ? @ShankerV  Your response is highly appreciated