Hi,
I am having some information about sales at SKU level (product), Store where it was sold and date.
I want to be able to aggregate all sales per Store and per day and than divide the SKU/Store/Data information to the total sales per Store/Day.
My loading script looks like this:
Directory;
LOAD
POC.DATE,
POC.Store_CODE,
POC.SKU,
POC.Sales
FROM
(qvd);