topic Re: QVD Concatenate New Records Only in App Development

QVD Concatenate New Records Only

esuper21 — Mon, 20 Dec 2021 21:32:42 GMT

I am trying to concatenate new records into my existing qvd file based on one field. I need today's record added in when new records are added as well.

So far, I can add new records, but it adds ALL new records - only need where it doesnt exist in the original file

Script now: y =yesterday // x = today

Stat:
LOAD
*
FROM 'lib://AT Prod Folder/ITAMOR24_$(y).qvd'(qvd);

Concatenate

LOAD
SerialNumber,
"Date Added"
Resident ATOR24
where not exists(SerialNumber, "SerialNumber");

store Stat into 'lib://AT Prod Folder/ITAMOR24_'$(x).qvd(qvd);

Results:

I need the new highlighted record with 3/17 date and only that one for 3/17. The rest already had existing records so I don't want to add again.

Re: QVD Concatenate New Records Only

martinpohl — Tue, 17 Mar 2020 13:55:11 GMT

because of your

not exists (SerialNumber)

you won't load datas from your database that are in the qvd.

So change the reload order.

First database, all new and changed datas and then the old datas.

Regards

Re: QVD Concatenate New Records Only

esuper21 — Tue, 17 Mar 2020 14:18:14 GMT

I am *trying* to exclude records from the database that already in the qvd file. But it is adding everything still day-to-day