Master Calendar with multiple dates, linking table
Hi,
I have been working on solving this issue for a long time, and have had no luck.
I hope that one of you, experts, will be able to put me on the right track.
When running the following script:
Master_Calendar_Temp:
LOAD
$(vMinDate) + (RecNo()/24) + (IterNo() - 1) AS Date_Temporary,
//would like to resident load a field here!!
AUTOGENERATE 24 WHILE num($(vMinDate) + IterNo() -1) <= num($(vMaxDate));
is it possible to perform "autogenerate 24" (hourly increments) and Resident Load at the same time?
I need to generate missing hourly intervals for multiple date types, indicated by the DateType field, which I would like to resident load as part of the script.
Or, maybe, there is another way of accomplishing something like this?
Could you upload a small, reloadable sample QVW of your current setting?
I assume you are currently using a canonical date (which is a timestamp in your case?) and you want to link the date part and time part of this canonical field to a master calendar / master time table?
