getting new data when reloading

[rathnam_qv]

hi all,

is there any way to get newly added data with old data from qvd when we are using button with reload actions...can any one help me urgent

[michael_maeuser]

you can do an incremental load. s.th. like that

TestTable:

LOAD

Key,

A,

B,

C;

FROM

\QVD\Test.qvd

(qvd);

UNQUALIFY *;

//Get latest value from QVD

TEMP:

LOAD Max(Key) as MaxKey

RESIDENT TestTable;

LET vExample=peek('Max%Key',-1,'KeyTEMP');

drop Table TEMP;

//Add new values

Concatenate (TestTable)

Entries:

LOAD

Key,

A,

B,

C;

SQL SELECT *

FROM "$(Database)".dbo."$(Company)$Entries"

WITH (NOLOCK)

WHERE "Key" > $(vExample)

;

[techvarun]

Pls Do Incremental LOAD

Regards