8 Replies Latest reply: Apr 3, 2012 7:20 AM by Matthew Fryer RSS

    How to fill missing values?

      Hi all,

      I have this king of table (with thousands of Materials):

      i need to fill the missing Cost values folow the last known value.

      for example: for 201101 to 201109, need to set value of 10.65 (folow what i had in 201012)

      Is there any smart way to do it without a long long loop?

       

      Material Number Year YearMM Cost
      1
      110390 2010 201001 1
      110390 2010 201002 1
      110390 2010 201003 1
      110390 2010 201004 1
      110390 2010 201005 1
      110390 2010 201006 1
      110390 2010 201007 1
      110390 2010 201008 1
      110390 2010 201009 1
      110390 2010 201010 1
      110390 2010 201011 1
      110390 2010 201012 10.65 1
      110390 2011 201101 1
      110390 2011 201102 1
      110390 2011 201103 1
      110390 2011 201104 1
      110390 2011 201105 1
      110390 2011 201106 1
      110390 2011 201107 1
      110390 2011 201108 1
      110390 2011 201109 1
      110390 2011 201110 18.65 1
      110390 2011 201111 18.65 1
      110390 2011 201112 18.65 1

       

      Thanks in advance,

       

      Tzur