4 Replies Latest reply: Dec 10, 2014 3:51 PM by Peter Rieper RSS

    Concatenating rows with existing qvd not having data of previous day

    Durgesh Singh

      Dear All,

      I am trying to make a qvd with gets updated every day with its date

      i.e. data to be concatenated with the previous qvd each day with every successive date with out repeating last day data

       

      m trying this:

       

      Tab1:

      SQL

      Select

      Order No,

               Ship_date as Link_date,

               Order Quantity

      From abc;

       

      Noconcatenate

      Tab2:

      LOAD Order No,

                Link_date,

               Order Quantity

      From abc;

      CONCATENATE(Tab2)

      LOAD *

      RESIDENT tab1

      where not exists(Link_date,Link_date);

      Drop table tab1;

       

      Data should come like below

       

      link_date          order no     order quantity

      09/12/2014           001             40              

                               .

                                 100             20

      10/12/2014           101            100

                                 300            400

      11/12/2014           301             50

                                 350             100

       

      continued...

       

       

      but concatenation is not happening

       

      Please help me.......