I am guessing a bit here, but what if you try to use interval match. See sample script below.
///Your table (1) containing dates
Table_1:
LOAD
dayname(makedate(2023,11,12)+ recno()) as Date
AutoGenerate 28;
//Your table (2) containing weeknumber and an end date for that week
Table_2:
LOAD * Inline [
Week, WeekEndDate
W49, 2023-12-10
W48, 2023-12-03
W47, 2023-11-26
W46, 2023-11-19
];
//Intervalmatching dates based on weekstartdate (calculated) and weekenddate
IntervalMatch(Date)
LOAD
WeekStart(WeekEndDate) as WeekStartDate,
WeekEndDate
Resident Table_2;
I must admit that I find the interval function hard to understand. Besides that I am not sure it can be used in my situation. What I did not mention is that the weeknumbers cover a period of two years and are overlapping. Please have a look at my tables and the result I am looking for.
