7 Replies Latest reply: Oct 8, 2014 6:38 PM by Gerardo Pauza RSS

    take off 1 day on load script

    Gerardo Pauza

      Hi everyone, could you please help me to modified the following load script?

       

      Load

      GRTVAL_CMPVER,
      GRTVAL_CODCOF,
      GRTVAL_DEBAJA,
      GRTVAL_FECALT,
      GRTVAL_FECCAL,
      Year(GRTVAL_FECCAL) & Num(Month(GRTVAL_FECCAL),'00') & Num(Day(GRTVAL_FECCAL),'00') as %Key_CREATED_ITEMS_MOVIMIENTOS_VENTAS,
      GRTVAL_FECMOD,
      GRTVAL_HORMOV,
      GRTVAL_LOTORI,
      GRTVAL_LOTREC,
      GRTVAL_LOTTRA,
      GRTVAL_MODULE,
      GRTVAL_OALIAS,
      GRTVAL_SYSVER,
      GRTVAL_TSTAMP,
      GRTVAL_ULTOPR,
      GRTVAL_USERID,
      GRTVAL_VALORI
      FROM [C:\Qlikview-Datos\AR_CAMBIO_USS.QVD] (qvd)

       

      what i have is

      datevalue
      10/1/20144
      10/2/20145
      10/3/20146
      10/4/20147

       

       

      but what i need is

      datevalue
      10/2/20144 (10/1/2014 value)
      10/3/20145 (10/2/2014 value)
      10/4/20146 (10/3/2014 value)
      10/5/20147 (10/4/2014 value)

       

      is it clear?

      thanks!