Partial reload for QVW like incremental for QVD

[#1]

Hello all,

I created incremental load for QVD and worked... but how I do "incremental" - partial reload for QVW

How can do something like below example for a partial reload for QVW

This is incremental load for QVD (with insert and update)

TAB:

LOAD  MaxString(VALID_BEGIN) AS MAXDATE

FROM C:\Users\Adi\Desktop\CLAIM.QVD (qvd);

LET currentmaxdate= DATE#(PEEK('MAXDATE',0,'TAB'),'DD/MM/YYYY');

SET PrimaryKey = CLAIM_ID& ' ' &ID& ' ' &VALID_BEGIN;

CLAIM:

LOAD $(PrimaryKey) AS PK , *

FROM

'C:\Users\Adi\Desktop\CLAIM.xlsx'

(ooxml, embedded labels, table is Sheet1)

where VALID_BEGIN >= '$(currentmaxdate)' ;

Concatenate LOAD * FROM 'C:\Users\Adi\Desktop\CLAIM.QVD'(QVD)

WHERE NOT Exists(PK, $(PrimaryKey)) ;

DROP FIELD PK;

STORE CLAIM INTO 'C:\Users\Adi\Desktop\CLAIM.QVD'

Any idea?!

[jvitantonio]

You can use the Exist functions

If you have a tableA with a key KeyA then do:

LOAD * FROM yourQVD.qvd (qvd)

where not exists(KeyA);

[#3]

And how can I use for UPDATE and INSERT into QVW?

Partial reload support only ADD or REPLACE.

I tested but don't work or I missed something... here it's the code

IF IsPartialReload() then

SET PrimaryKey = CLAIM_ID& ' ' &VALID_BEGIN;

CLAIM:

LOAD $(PrimaryKey) AS PK , *

FROM

C:\Users\Administrator\Desktop\CLAIM2.qvd   //have 120 rows (update and insert - no delete)

(qvd)

WHERE NOT Exists(PK, $(PrimaryKey)) ;

DROP Field PK ;

else

CLAIM:

LOAD  *

FROM

C:\Users\Administrator\Desktop\CLAIM.qvd   //have 100 rows

(qvd);

end if;

[jvitantonio]

Sorry, but what's the problem with the code?

[#5]

I think I solved...

But I see is running much harder with partial reload than full reload.... Is normal? because for me is much important the speed

[#6 · Accepted solution]

after I struggled for hours with it.... I don't used because running more than an full reload

Thanks qlikuser14 for help.

This is the right code for me for partial reload(update+insert):

SET PrimaryKey = CLAIM_ID& ' ' &VALID_BEGIN;

IF IsPartialReload() then

CLAIM:

REPLACE ONLY LOAD $(PrimaryKey) AS PK , *

FROM

C:\Users\Administrator\Desktop\CLAIM2.qvd

(qvd)

WHERE Exists(PK,$(PrimaryKey)) and VALID_UNTIL <> '31/12/9999 00:00:00';

CLAIM:

ADD ONLY LOAD $(PrimaryKey) AS PK , *

FROM

C:\Users\Administrator\Desktop\CLAIM2.qvd

(qvd)

WHERE NOT Exists(PK,$(PrimaryKey)) ;

else

CLAIM:

LOAD $(PrimaryKey) AS PK, *

FROM

C:\Users\Administrator\Desktop\CLAIM.qvd

(qvd) ;

end if;