2 Replies Latest reply: Jan 14, 2012 10:16 AM by Przemysław Wojda RSS

    Autogenerate + Select = Master Calendar with holidays

    Przemysław Wojda

      Hi All,

       

      I'm trying to create a master calendar that will have a dim showing date type i.e. holi or working day. Calendar is an autogenerated set but holidays come from sql table (records present only holidays). Please take a look at the below example and suugest what to do to join them.

       

      Input:

      --------

      LOAD

      Date(Date#(20111231,'YYYYMMDD')+RecNo(),'YYYY-MM-DD') AS Date,

      AUTOGENERATE Today() - MakeDate(2012, 1, 1) + 1;

       

      SELECT Holiday FROM Holidays

       

       

      Output:

      ----------

      2012-01-01, holiday

      2012-01-02, working day

      ...

       

       

      Thanks,

      Przemek