Update qvd, need help

[#1]

Hi all.

I want to update my qvd and make an incremental load with my database. So, my table is :

Id (primary key) integer

Status              varchar

Name               varchar

Date                 date MM/DD/YYYY

For this, my script is :

Let ThisExecTime = ReloadTime();

QLIKVIEW_TEST:
SQL SELECT *
FROM DB.QLIKVIEW_TEST
WHERE (Date>= convert(DateTime,'$(ThisExecTime)',103));

Concatenate LOAD Id, Statut, Name, Date
FROM QLIKVIEW_TEST.qvd (qvd)
WHERE NOT EXISTS (Id);

store QLIKVIEW_TEST into QLIKVIEW_TEST.qvd(qvd);
Drop table QLIKVIEW_TEST;

But I can't update my table.

Please, i need you.

Regards,

[Sokkorn]

Hi,

Please check in my attached file in http://community.qlik.com/message/173636#173636

Regards,

Sokkorn Cheav

[rwunderlich]

You might want to check out using Qlikview Components (Qvc) http://QlikviewComponents.org for incremental loads. Here's how your code would look using Qvc.

$(Include=path-to-qvc\qvc_runtime\qvc.qvs)

CALL Qvc.IncrementalSetup ('QLIKVIEW_TEST', 'Date', 'Id');

[$(Qvc.Loader.v.Tablename)]:

SQL SELECT *

FROM DB.QLIKVIEW_TEST

WHERE $(Qvc.Loader.v.IncrementalExpression)

;

CALL Qvc.IncrementalStore;

-Rob

http://robwunderlich.com