Master Calendar Help

[Anonymous]

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

[its_anandrjs]

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

[Anonymous]

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

[its_anandrjs]

Provide any sample file or what is min and max date in the model.

Regards

Anand

[Anonymous]

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

[its_anandrjs]

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