2 Replies Latest reply: Mar 15, 2011 2:24 AM by Nicolas ALLANO RSS

    Script distinct date + append 12 coming month

      Hello,

      I want to retrieve all distinct dates (all in format MMM YYYY, using MonthName function) from my fact table and then append them by the next coming 12 months, here is my script but it is not working. Any suggestion

      tmp:
      Load Distinct OpenMonth as newDate
      Resident Fact;
      CONCATENATE (tmp)
      LOAD
      MonthName(Max(OpenMonth),IterNo()) as newDate
      RESIDENT Fact
      while MonthName(Max(OpenMonth),IterNo()) <= MonthName(Today(),12)
      ;