topic Re: problem QVD in Management & Governance

problem QVD

zied_ahmed1 — Wed, 31 May 2017 09:46:46 GMT

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);

Re: problem QVD

tajmohamed30 — Wed, 31 May 2017 10:02:58 GMT

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

Re: problem QVD

migueldelval — Wed, 31 May 2017 10:04:14 GMT

Hi Zied,

Why are you loadind fields from resident table?

I´m trying to understand better your process.

Regards

Miguel

Re: problem QVD

Aurelien_Martinez — Wed, 31 May 2017 10:07:33 GMT

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);