Distribute values in multiple rows

PriyamChatterjee9

Hi all, I want to distribute a value in multiple rows using Alteryx. Let's say, the value is as below,

name	amount
abc	100

Now I want the max value in the "amount" column will be 30. That means there will be three rows having the "amount" as 30 and one extra row with the rest of the amount (here in this case it will be 10).

name	amount
abc	30
abc	30
abc	30
abc	10

Any idea on how to achieve this one. All kind of suggestions are much appreciated. Thanks!

philipmannering

What about this...

Distribute Values.yxmd