Hi community,
I'd like to use 2 tables in my datamodel, but I'm facing with a known issue:
ProductionStatus:
load * inline [
date, status
01.01.2020, 1
05.01.2020,2
24.01.2020,3
];
MasterCalendar:
load * inline [
date,month,day
01.01.2020,1,1
02.01.2020,1,2
03.01.2020,1,3
[...]
31.01.2020,1,31
];
Well, my first idea was to create an additional column within my ProductionStatus table to build a rdate range and use intervalmatch as described here
Is this approach the only way or is it possible without creating an additional column?
