3 Replies Latest reply: Feb 10, 2013 2:20 PM by umair lateef RSS

    filling blank dates with previous data

      CLIENT NOCLIENT NAME DATECCY PROD TYPEAMOUNT
      010000000ASDFG1/1/2012EURLRP56,987
      010000001ASDFGDSF2/1/2012USDFGT54,785
      010000002ASDFASDFASDF3/1/2012USDBGO62,314
      011000003ASDSASDE4/1/2012USDPBG56,987
      011000004SADEDSA6/1/2012USDPBG25,558
      011000005ASEDF7/1/2012USDPBG69,874
      011000006ASDFTED8/1/2012USDPBG58,461
      011000007ADSFE12/1/2012USDBGO56,987
      011000008FAFOOOASF13/1/2012USDBGO54,785
      011000009ADSFLLLL14/1/2012USDBGO62,314
      011000010ADLFOPP15/1/2012USDBGO23,268
      011000011AFQER16/1/2012USDBGO23,654
      011000012INTER LTD.17/1/2012USDBGO2,828
      011000013VSAFD23/1/2012USDBGO56,987
      011000314ASDFRRYGFS24/1/2012EURBGO54,785
      011200015ADSFACVR25/1/2012SARBGO62,314
      011200216ASDFEFCC26/1/2012SARBGO23,268
      011200517ADSFVHT27/1/2012USDPBG56,987
      011200618AQEWER28/1/2012USDPBG54,785
      011200619CVREFASDF29/1/2012USDPBG62,314
      011200620ASDFCWE30/1/2012USDPBG56,987

       

      Hi

      I have a following data, in this data i have some dates missing like  5/1/2012 , 9-11/1/2012, 18-22/1/2012 these are the holydays and  there is no data in them what i want is that in these dates the previous date customers data should be copied. i need the script for. if there is a difference of one date like 5/1/2012 in that i need the data of 4/1/2012 and from 9-11/1/2012 i need the data of 8/1/2012

      i have used date dimension too.