To Create Multiple Record View & Assorted Assigned numbers

Database

To Create Multiple Record View & Assorted Assigned numbers

Hi Experts,

I need to create view and new column from various data source.My desired intentions are to:
1. Create multiple records. The number of records is based specific quantifier (of which derived from specific column created
2. Assigned assorting numbers to each record
Notes: The assigned number is flexible and dynamic whereby it can be randomly assigned or based on certain parameters for example date, amount

Example:
Customer Account_number Quantifier
A 12563 3
A 15152 2
B B2551 1

Customer Account_number Quantifier Assigned Number
A 12563 3 1
A 12563 3 2
A 12563 3 3
A 15152 2 4
A 15152 2 5
B B2551 1 6