How to append the data to the QVD file by daily?

[#1]

Hi there,

i want to create a QVD file, and append the data by daily.

how to create a load script?

thank you in advance!

[Gysbert_Wassenaar]

Did you search for any resources before posting this question?

If not: https://community.qlik.com/search.jspa?q=incremental+load&type=document

If you did, please explain the specific problem that you have and couldn't find an answer for in previously posted discussions.

[kamakshisuram]

Hi,

I can not able to attach the file.

Please find code below and modify accordingly. This is working fine.

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Let vFileExsist=isnull(QvdCreateTime('C:\Users\nkamakshi\Desktop\Qlikview\case.qvd'));

if $(vFileExsist)=0 then

  LOAD  CreateDt

    FROM case.qvd(qvd);

  LET VCreateDt = peek('CreateDt',-1,'Case');

  Case:

  LOAD [Create Date] as CreateDt,

     Region,

     Country,

     Case_Vol

  FROM

  (ooxml, embedded labels, table is Sheet1)

  where [Create Date]>$(VCreateDt);

  Concatenate(Case)

  LOAD CreateDt,

     Region,

     Country,

     Case_Vol

FROM

(qvd) where Not Exists(CreateDt) ;

Store Case into case.qvd;

ELSE

  Case1:

  LOAD [Create Date] as CreateDt,

     Region,

     Country,

     Case_Vol

  FROM

  (ooxml, embedded labels, table is Sheet1);

  Store Case1 into case.qvd;

ENDIF