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
