problem QVD

[zied_ahmed1]

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

into $(vQvdPath);

[tajmohamed30]

tried where not exist function, or save it as new QVD

[migueldelval]

Hi Zied,

Why are you loadind fields from resident table?

I´m trying to understand better your process.

Regards

Miguel

[Aurelien_Martinez]

Hi,

Try :

Data:

Load

  date*1 as [%Date ID],

  Type_M,

  Taxe,

  car,

  car_two

Resident Flotte2 where "date"= Today()

;

Concatenate(Data)

Load

  Type_M ,

  Taxe,

  car,

  car_two,

  [%Date ID]

FROM $(vQvdPath)

Where not exist ([%Date ID], [%Date ID]);

store Data into $(vQvdPath);