4 Replies Latest reply: Apr 3, 2016 6:47 AM by Sunny Talwar RSS

    RE:load issue

    Chanty 4u

      Hi all,

       

      I  have issue on Loading new data into existing data.

       

      i have script below

       

       

       

      ZREJ_TRACWHEAT1:

      LOAD WHEAT_REJ_VENDOR_CODE,

          

      D:\..\..\TransformQVDs\ZREJ_TRACWHEAT.qvd

      (qvd) where (( WHEAT_REJ_SOB_QTY<-5000) and  (WHEAT_REJ_DATE<=Date('31/08/2015')) and (SOB_MOVEMENT_TYPE<>101)) ;

      STORE ZREJ_TRACWHEAT1 into $(vQVDTargetDir)ZREJ_TRACWHEAT1.qvd(qvd);

       

      Here   i need to  into insert the data  after  31/08/2015'    to till date ....

       

      how can i add the latest data into this?

       

       

      Thanks in advance.