Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
tried where not exist function, or save it as new QVD
Hi Zied,
Why are you loadind fields from resident table?
I´m trying to understand better your process.
Regards
Miguel
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);