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.
Hi @vmanika8
Step 5:
Step 6:
Step 7:
Many thanks
Shanker V
One way of doing this.
Step 1: Input
Step 2:
Step 3:
Step 4:
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!
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.
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
