topic Re: Incremental Load for excel file in QlikView

Incremental Load for excel file

vikasmahajan — Fri, 14 Aug 2015 05:58:27 GMT

Dear all,

I have excel file containing lacs of records I have stored this into qvd and then now I am reloading from QVD.

Now I want to apply incremental load for this excel sheet I have date field as PK.

Please share demo or give idea how to do this .

Thanks

Vikas

sunny_talwar — Fri, 14 Aug 2015 06:03:54 GMT

This presents the basic idea:

QVDFile

LOAD *

FROM QVD.qvd;

MaxDate:

LOAD Max(Date) as MaxDate

Resident QVDFile;

LET vMaxDate = Peek('MaxDate');

DROP Table MaxDate;

Concatenate(QVDFile)

LOAD *

FROM Excel

Where Num(Date) > $(vMaxDate);

STORE QVDFile into QVD.qvd (qvd);

HTH

Best,

Sunny

senpradip007 — Fri, 14 Aug 2015 06:04:09 GMT

Hi Vikas,

If you have date field as PK, take the latest date from QVD and load the data after that max date.

vikasmahajan — Fri, 14 Aug 2015 06:09:41 GMT

Thanks

Vikas

sunny_talwar — Fri, 14 Aug 2015 06:13:26 GMT

No problem Vikas,

Best,

Sunny