6 Replies Latest reply: Apr 5, 2013 6:55 AM by Riko Mahr RSS

    Problem with CONCATENATE, STORE and WHERE function of 2 tables.

      Hi everybody,

       

      I have following problem.

      I have one Datasource with always adding data. If we send a new parcel, the table will be added:

      See example:

      Packaging-Table.JPG

      The Problem ist, that the oldest entries (Date, Time) in that table will be deleted after a while. But I will keep them in QlikView.

       

      So, I will try following:

       

      Send1:
      LOAD    DATE,
                      TIME,
                      WEIGHT,
                      TIMESTAMP
      FROM
      C:\colli.qvd
      (qvd);
      
      
      Send2:
      CONCATENATE 
                      LOAD DATE&TIME as TIMESTAMP
      Select       DATE,
                      TIME,
                      WEIGHT
      FROM QS36F.PACKAGING
                      WHERE SEND2.TIMESTAMP > SEND1.TIMESTAMP;
      STORE * FROM Send2 INTO  C:\colli.qvd
      

       

      But I do not know how to do it right and I can not find anything in the web about it.

       

      I need to compare the timestamp from table 2 (Send2) with the timestamp in Table 1 (Send1) to get only the data from table "Send2" which is not contained in table "Send1".

       

      Can soembody help me?

       

      I appreciate your fast help.

       

      regards ...