Joined: 03 May 2008
Location: New York
|Posted: Sat May 03, 2008 2:20 am Post subject: Feature Request: Distributing numeric data randomly
This would be a really cool feature, and I believe other users may have similar needs to my own. If this feature already exists, please let me know.
To be able to Randomly generate a single numeric quantity is great, but would it be possible to take that quantity and, when generating records for another table, be able to distribute that value amongst a random number of records.
For example, assume the following schemae exist:
Where A.Sum equals the sum of B.Amount where B.AId = A.AId
There are two directions that can be taken to satisfy this need: either I can generate B records and then add them up into A (min/max values on the sum of all B records that share AId values would be great), or I can take the A.Sum quantity and distribute it randomly amongst a random number of B records, as in:
A.AId = 1, A.Sum = 10000
B.BId = 1, B.AId = 1, Amount = 200
B.BId = 2, B.AId = 1, Amount = 4000
B.BId = 3, B.AId = 1, Amount = 4800
B.BId = 4, B.AId = 1, Amount = 1000
Any interest in adding these solutions as features?