i have a question, Is there any technique or procedure, how to implement FromDate and ToDate in Master Calender to use as one Field?
Thanks a lot for any feedback and response
thanks a lot for your feedback and response, i postet to this issue an another issue:
do you have any idea?
i solved this issue by this way:
load date(FROMDATE + iterno() - 1) as DATE, [Amount] / (TODATE - FROMDATE) as DailyAmoount
from Source while FROMDATE + iterno() - 1 <= TODATE;
and after reload i do concatenate the Field: DATE with MasterCalender
i hope that helps