Auto generate data based on existing DB + Factors

[seWork]

Hi all,

I'm wondering how could I autogenerate new data as described in the following script scenario?

I would like to auto-generate new records based on averages from the existing data by categories as described below

//ORIGINAL ITEMS DATA

1st table:

Load

Item

[Item description]

Category

Supplier

[Quantity units in a case]

[Quantity cases in a pallet]

[Quantity units in pallet]

[Unit Height]

[Unit Width]

[Unit Length]

[Unit Weight]

[Unit vol]

From table1.qvd;

//FACTORS FOR DATA GENERATION BASED ON INPUTFIELDS + MACRO FOR FACTORS EXPORTING

2nd table:

Load

Category

Count(Distinct Item) as [Quantity of items]

[Growing factor]

from table2.qvd;

//Category's Avg values for data generation

3rd table:

Load

Category

avg([Quantity units in a case])

avg([Quantity cases in a pallet])

avg([Quantity units in pallet])

avg([Unit Height])

avg([Unit Width])

avg([Unit Length])

avg([Unit Weight])

avg([Unit vol])

Resident table1.qvd

group by Category;

Concatenate(1st table)

4th table:

Load

Random (Item) // Should be autogenerate

Random (Item description) // Should be autogenerate

Category// Based on category list from 3rd table

Random(Supplier) // Should be autogenerate based on exists data(Randomly)

auto generate ceil([Quantity of items]*[Growing factor]) - [Quantity of items];

// Should autogenerate the number of required records by category

left join

Load *

Resident  3rd table;

Thank you