3 Replies Latest reply: May 31, 2017 6:07 AM by Aurélien Martinez RSS

    problem QVD

    Zied Ahmed

      Hello,

      I load data in QVD since today,

      the problem is when i reload i will have the data of today and the data will duplicate and this is the code :

       

      Table:  

        load

        Type ,

        taxe,

        car,

        car_two,

        AutoNumber(date(date, 'DD/MM/YYYY'),'%Date ID') as [%Date ID]

        FROM $(vQvdPath);

       

          Concatenate

        load AutoNumber(date(date, 'DD/MM/YYYY'),'%Date ID') as [%Date ID],

        date,

        Type_M ,

        Taxe,

        car,

        car_two Resident Flotte2 where "date"= Today() ;

         STORE [Table] into $(vQvdPath);