How to achieve the result that appear in third image from first two images?

[silambarasan]

Image  1:

Image  2:

Result

[Gysbert_Wassenaar · Accepted solution]

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.

[silambarasan]

Thank you so much.I got it..How to improve these skills and all..pls reply

Gysbert Wassenaar

[silambarasan]

super