Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
MalcolmCICWF
Contributor II

Incrimental QVD Load Problem

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:

Capture.JPG.jpg

1 Solution

Accepted Solutions
Employee
Employee

Re: Incrimental QVD Load Problem

Use

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

4 Replies
Employee
Employee

Re: Incrimental QVD Load Problem

Use

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

MalcolmCICWF
Contributor II

Re: Incrimental QVD Load Problem

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?

Employee
Employee

Re: Incrimental QVD Load Problem

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

MalcolmCICWF
Contributor II

Re: Incrimental QVD Load Problem

hmmm thank you

Community Browser