Create missing days in calendar

[anjali0108]

Hi All,

I have a requirement where the client wants to see all the days in calendar irrespective of whether the data is present or no in the files that were shared to us.

I am making day,month and year from the common date that I am forming by using the file names.

Everything is working fine for me. The only requirement is customer wants to see the missing days also in the calendar,

Client is ok if no data comes for that respective selection but all days should come.

Hope this explains my requirement.

Thanks.

[Anil_Babu_Samineni]

May be Master Calendar Generation Script

[sunny_talwar]

A master calendar script should do this for you

Creating A Master Calendar

[its_anandrjs]

You can join your calendar with your transaction table then.

Ex:-

fact:

Load

Comman_Date

*,

From Source;

Left Join(fact)

Calendar:

Load

Comman_Date,

Month,Day,Year

From Source;

[anjali0108]

Thank You All for the quick revert.

I will try the same and revert. Thank You

[its_anandrjs]

Find the attached and let me know with this way you can try in your solution.