Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please find my below Master Calendar script. The issue is,when I am selecting some dates it is working fine. For some of date,though I am having a value in the table,still it is not showing the date. Am I missing any thing in the script?
-Jay
Service:
Load Key,
Service_Creation_Date
From Service.xl;
Application:
Load Key,
Key1,
Application_Creation_Date
From Application.xl
Point:
Load Key1,
Point_Creation_Date
From Point.xl;
Temp_Cal:
Load Service_Creation_Date
Resident Service;
Concatenate
Load Application_Creation_Date As Service_Creation_Date
Resident Application
Concatenate
Load Point_Creation_Date As Service_Creation_Date
Resident Point;
Min_max_Date:
Load Min(Service_Creation_Date) As Min_Date
Max(Service_Creation_Date) As Max_Date
Resident Temp_Cal;
Let V_min=Num(Peek('Min_Date','0,'MinmaxDate');
Let V_max=Num(Peek('Max_Date','0','MaxMaxDate');
Temp_Cal_Creation:
Load Date($(V_min)+Rowno()-1) As Cal_Date_Creation
AutoGenerate $(V_max)-$(V_Min)+1;
Master_Calendar:
Load Cal_Date_Creation As Service_Creation_Date
Resident Temp_Cal_Creation;
Drop Tables Temp_Cal_Creation,Min_max_Date,Temp_Cal
Hi,
Try this this is your complete script
Service:
Load Key,
Service_Creation_Date
From Service.xl;
Application:
Load Key,
Key1,
Application_Creation_Date
From Application.xls;
Point:
Load Key1,
Point_Creation_Date
From Point.xls;
Temp_Cal:
Load Service_Creation_Date
Resident Service;
Concatenate
Load Application_Creation_Date As Service_Creation_Date
Resident Application;
Concatenate
Load Point_Creation_Date As Service_Creation_Date
Resident Point;
Min_max_Date:
Load Min(Service_Creation_Date) As Min_Date,
Max(Service_Creation_Date) As Max_Date
Resident Temp_Cal;
LET V_min = Num(Peek('Min_Date',0,'Min_max_Date'));
Let V_max = Num(Peek('Max_Date',0,'Min_max_Date'));
Temp_Cal_Creation:
Load Date($(V_min) + Rowno() - 1) As Cal_Date_Creation
AutoGenerate $(V_max) - $(V_Min) + 1;
Master_Calendar:
Load Cal_Date_Creation As Service_Creation_Date
Resident Temp_Cal_Creation;
Drop Tables Temp_Cal_Creation,Min_max_Date,Temp_Cal;
Regards,
Anand
Hi Anand,
If I am not wrong, you have updated the variable declaration part. But still I am having the same issue.
For Ex: If I select11/26/2014 from Master calendar even if I have date present at Application table, but those dates are not get selected.
This is my issue. Kindly let me know if you have any ideas?
-Jay
Provide any sample file or what is min and max date in the model.
Regards
Anand
Due to data sensitivity Iwont be able to share the data. Like any other Date fields, it is just simple Date field.As I said earlier though I am having value in tables,it is not get selected when I am selecting the Dates in Master Calendar
-Jay
Hi,
Then individually load table one by one and check this dates come or not in the table and then check in the tables after concatenate in the tables for field Service_Creation_Date. And then load min and max fields.
You can provide any sample file with few records.
Regards
Anand