2 Replies Latest reply: Sep 7, 2011 10:05 AM by Gangadharan M RSS

    Fill empty field with previous value.

      Hi All,

       

      First one is actual data, the second is the required result.

      Actual.bmp Result.bmp

       

      Code:

       

      let Start = floor(makedate(1971,01,01));
      let End = floor(today())+1;

      let NoOfDays = End - Start;

      Cal1:
      Load
      $(Start)+recno()-1 as Date
      autogenerate
      $(NoOfDays);


      Cal2:
      Load
      Year(Date) as Year
      resident Cal1;

      DROP Table Cal1;


      A:
      LOAD
      Year,
      Sales
      FROM
      SNO.xls
      (biff, embedded labels, table is Sheet1$);

       

      Final:
      Left Join(Cal2)
      Load
      Year,
      Sales,
      Year as Year1
      resident A;

       

      Drop Table A;

      All kind of suggestions/solutions are most welcome.

      Thanks

      Gangadharan