Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental Load (Append Into QVD File)

hello dears.

i implemented Incremental Load (Insert ,Update ,Delete)

i have a problem .

for the first time , i created qvd File. (i don't problem)

         

let vQVDExistsFile=isnull(QvdCreateTime('$(vSourceQvdFile)SaleQVD.qvd'));

if vQVDExistsFile=-1 then

  Sale:

  LOAD OrderId,

      ProductId,

      CustomerId,

      Amount,

      Date_Updated,

      Num(Date_Updated) as NumDate

  FROM

  $(vSourceData)Sale.xlsx

  (ooxml, embedded labels, table is Sheet1);

  Store Sale into $(vSourceQvdFile)SaleQVD.qvd(qvd);

END IF

I found that change records for the second time

But i Can not Append into SaleQVD.qvd

All New Records (Update,Delete) Override into SaleQVD,Not Append

10 Replies
Not applicable
Author

no , i want Implemented Incremental Load on fact Tables  With millions Record.

i want Test And Applied in Fact Table