Date and Datetimestamp asscociation problem while creating Master Calendar

[#1]

Hi All

I am facing Dates and datestamp association problem while creating Master Calendar,My sample data having  Datetimestamp and just Dates(no timestamp).I would expect output results like  EVery 'id' want to show their respective Dates But my calendar showing Null values.Can you please see the below image for your refernce.Here is the attaching sample QVW and sample data.Please guide me how to avoid null values in calendar table.

! !

[sunny_talwar]

Can you check now

[#3]

Hi Sunny,

I can't see nothing here ,did you post anything ?

[sunny_talwar]

Open this link: Re: Date and Datetimestamp asscociation problem while creating Master Calendar

[sunny_talwar · Accepted solution]

Here is the script I used:

ABC:

LOAD Date,

Floor(Date) as DateLink,

    Id

FROM

[DateTimestamp.xlsx]

(ooxml, embedded labels, table is ABC);

Concatenate(ABC)

LOAD Date,

  Floor(Date) as DateLink,

    Id

FROM

[DateTimestamp.xlsx]

(ooxml, embedded labels, table is XYZ);

Concatenate(ABC)

LOAD Date,

  Floor(Date) as DateLink,

    Id

FROM

[DateTimestamp.xlsx]

(ooxml, embedded labels, table is [ CBZ]);

CalendarMaster:

NoConcatenate LOAD

  1 as flag,

    Date(Date, 'DD/MM/YYYY' ) AS DateLink,

    Year(Date) AS Year,

    'Q' & Ceil(Month(Date) / 3) AS Quarter,   

    Month(Date) As Month,

    Day(Date) As Day,

    WeekDay(Date) as Calendar_Weekday,

    Week(Date) As Week;

Load Date(MinDate + IterNo() -1 ) AS Date While (MinDate + IterNo() - 1) <= Num(MaxDate);

Load Floor(Min(Date)) AS MinDate,

    Floor(Max(Date)) AS MaxDate

RESIDENT ABC;