Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Image 1:
Image 2:
Result
Try this script:
Pricing:
LOAD Product,
Start,
End,
Price
FROM [comm197554_pricing.xlsx] (ooxml, embedded labels, table is Sheet1);
Scenario:
LOAD *, AutoNumber(RowNo(),Product) as Counter;
LOAD Product,
Date,
Qty
FROM
[comm197554_Scenario.xlsx]
(ooxml, embedded labels, table is Sheet1)
While IterNo() <= Qty;
left Join(Scenario)
IntervalMatch(Counter, Product)
LOAD Start, End, Product
Resident Pricing;
left Join(Scenario)
LOAD * Resident Pricing;
Drop Table Pricing;
Then create a straight table object with Product, Date and Qty as dimensions and sum(Price) as expression.
Try this script:
Pricing:
LOAD Product,
Start,
End,
Price
FROM [comm197554_pricing.xlsx] (ooxml, embedded labels, table is Sheet1);
Scenario:
LOAD *, AutoNumber(RowNo(),Product) as Counter;
LOAD Product,
Date,
Qty
FROM
[comm197554_Scenario.xlsx]
(ooxml, embedded labels, table is Sheet1)
While IterNo() <= Qty;
left Join(Scenario)
IntervalMatch(Counter, Product)
LOAD Start, End, Product
Resident Pricing;
left Join(Scenario)
LOAD * Resident Pricing;
Drop Table Pricing;
Then create a straight table object with Product, Date and Qty as dimensions and sum(Price) as expression.
super