Hello,
I saw Arthur already explained how IntervalMatch works.
I suspect you are looking for the function IterNo() instead of Interval match.
This will generate your table automatically regardless of any calendar ranges:
Marketing_Table:
LOAD
Channel
, Article_ID
, Num(Date#(Start, 'DD.MM.YYYY')) AS Start
, Num(Date#(Stop, 'DD.MM.YYYY')) AS Stop
, Price
, RowNo() as Marketing_TableID
;
LOAD * INLINE [
Channel, Article_ID, Start, Stop, Price
Newsletter, A, 30.01.2019, 31.01.2019, 600
Newsletter, A, 01.02.2019, 05.02.2019, 500
Flyer, A, 03.02.2019, 06.02.2019, 400
];
For i=0 to NoOfRows('Marketing_Table')-1
LET vEachRowCalID = peek('Marketing_TableID', $(i), 'Marketing_Table');
LET vEachRowCalStart = peek('Start', $(i), 'Marketing_Table');
LET vEachRowCalEnd = peek('Stop', $(i), 'Marketing_Table');
Calendar:
LOAD
'$(vEachRowCalID)' as Marketing_TableID,
Date( Start + IterNo() - 1 ,'DD.MM.YYYY') as Calendar
While Start + IterNo() - 1 <= Stop
;
LOAD
Start, Stop
RESIDENT Marketing_Table
WHERE Marketing_TableID='$(vEachRowCalID)'
;
Trace i;
NEXT i;
LEFT JOIN(Marketing_Table)
LOAD
Marketing_TableID,
Calendar
RESIDENT Calendar;
DROP TABLE Calendar;
I hope that helps!
Kind regards,
S.T.
