11 Replies Latest reply: Jul 21, 2014 6:48 AM by Marcus Malinow RSS

    Dealing with two dates

    Anuradha Abeysuriya

      I have below two dates and they are in two different tables, I want to use common date.

       

      Than i use master calander as belwo,

       

      [TempCalendar]:

      LOAD DISTINCT

          DATE,   

        Year(DATE) as Year,

        Month(DATE) as Month,

        'Q' & Ceil(Month(DATE)/3) as AQuarter

        RESIDENT ABC_DATA;

      join

      LOAD DISTINCT

        DATE,

        Year(DATE) as Year,

        Month(DATE) as Month,

        'Q' & Ceil(Month(DATE)/3) as Quarter

      RESIDENT Charges;

       

      MainCalendar:

      load DATE,

        Year,

        Month,

        Quarter

        Resident TempCalendar;

       

      Here i remane ABC_DATE and XYZ_DATE when i lod that table.

      But when i look at the table year,Month is missing in some recrds.

      Please help

       

      ABC_DATEXYZ_DATE
      5/30/2014 8:451/18/2014 23:50
      5/30/2014 8:453/25/2014 3:25
      5/30/2014 8:453/28/2014 10:11
      5/30/2014 8:454/2/2014 13:46
      5/30/2014 8:454/4/2014 9:45
      5/30/2014 8:454/14/2014 10:04
      5/30/2014 8:454/15/2014 3:00
      5/30/2014 8:454/15/2014 6:20
      5/30/2014 8:454/18/2014 8:49
      5/30/2014 8:454/18/2014 21:05
      5/30/2014 8:454/21/2014 13:46
      5/30/2014 8:454/26/2014 6:25
      5/30/2014 8:454/28/2014 10:30
      5/30/2014 8:455/5/2014 9:57
      5/30/2014 8:455/8/2014 1:20
      5/30/2014 8:455/10/2014 1:20
      5/30/2014 8:455/12/2014 10:37