3 Replies Latest reply: Oct 1, 2010 5:26 PM by ivan_cruz RSS

    Delete data after reload

       

      Hello:

      The question is:

      After reload data to my qlickview, with one SQL SELECT, is possible delete rows of this data, with some command? for example

      After SQL SELECT

       

      DATENunberCodAMOUNT
      11/10/201010cod110
      19/10/201020cod1115
      12/11/201022cod1200
      23/12/201030cod325
      15/09/201040cod140
      28/10/2010255cod1900
      01/11/201030cod325
      14/12/201015cod1100


      The data with the same number drop

      the result

       

      DATENunberCodAMOUNT
      11/10/201010cod110
      19/10/201020cod1115
      12/11/201022cod1200
      15/09/201040cod140
      28/10/2010255cod1900
      14/12/201015cod1100


      Any idea?

      Thanks!!, regards

      Cèsar Estrada

        • Delete data after reload

          Hi there, I dont quiet undertand the pattern you want to remove, do you want to remove rows with Amount equal to 25?? or rows with Cod equal to 30cod3??

          For either case try something similar to the following:

          Table:

          Load *

          where Cod <> '30cod3';

          sql select *

          from database;

          Regards

            • Re:Delete data after reload

              Hi Ivan

              I need delete row with the combination with the same number, code and amount.

              Thanks!

               

               

                • Re:Delete data after reload

                  Hi there, one thing i forgot is that is not recommended to do any filtering while you are load from the database, because it affects performance, for instance you can save the table in a qvd.

                  Try something similar to the following:
                  Test:
                  //replace with your sql load
                  LOAD * INLINE [
                  Prod, Date, Amount
                  A, 10/02/2000, 25
                  A, 11/02/2000, 25
                  B, 10/02/2000, 30
                  B, 20/02/2000, 30
                  B, 23/02/2000, 20
                  C, 1/02/2000, 45
                  D, 21/02/2000, 50
                  D, 22/02/2000, 50
                  ];
                  store Test into Test.qvd;
                  drop table Test;
                  Test:
                  Load Prod, date(max(date#(Date,'DD/MM/YYYY'))) as Date, only(Amount) as Amount
                  from Test.qvd (qvd)
                  group by Prod, Amount;

                  Regards.