topic Re: Incrimental QVD Load Problem in QlikView

Incrimental QVD Load Problem

MalcolmCICWF — Wed, 05 Nov 2014 14:33:25 GMT

I am comparing 2 QVDs with similar incrimental setups where then use the max date from a table to determine what is added each load. This would all be great, if my current QVD was working as intended.

I use the following to set the current max each QVD load:

load *;
sql select max(ADD_DATE) as temp1
FROM BTOffer.dbo.vw_CUSTOMER_CONTACT_all;
STORE * FROM currentmax INTO max_CustCon_CDRCallTran.qvd;
DROP TABLE currentmax;

I end up with what I expect, a single record with the last table load date like other Qvds setup similarly: "11/4/2014 4:00:48 PM"

Now when I pull from my max Qvd, I am getting multiple records (55 right now) of what look like settings. I use the following code at the start of the Qvd code, as I do in all our incrimentals, to grab the recent date:

load *
from max_CustCon_CDRCallTran.qvd;
let otherdate = text(date(peek('temp1',0,'pointless'),'YYYYMMDD'));
drop table pointless;

Data looking something like this:

Re: Incrimental QVD Load Problem

Clever_Anjos — Wed, 05 Nov 2014 15:24:30 GMT

Use

STORE * FROM currentmax INTO max_CustCon_CDRCallTran.qvd(qvd);

Re: Incrimental QVD Load Problem

MalcolmCICWF — Wed, 05 Nov 2014 17:04:46 GMT

Ok, I must have missed that when comparing to our other incremental loads. Why is it that peice saves the date correctly and without it you end up with like 55 records of settings info?

Re: Incrimental QVD Load Problem

Clever_Anjos — Thu, 06 Nov 2014 15:26:51 GMT

Without (qvd) QV will save your file as a text file (try opening it using notepad)

Re: Incrimental QVD Load Problem

MalcolmCICWF — Thu, 06 Nov 2014 15:48:52 GMT

hmmm thank you