topic Re: Incremental in QlikView

Incremental

abhaysingh — Mon, 30 Jun 2014 05:44:00 GMT

I want to pick last reload time in incremental load.. Can any one help me in this

thanks..

its_anandrjs — Mon, 30 Jun 2014 05:50:47 GMT

Use variables for that

Let vLastReload = NOW();

Let vLastReload = ReloadTime();

and use this variable in the incremental load script

Load *

From Location Where Datefield > $(vLastReload);

Mon, 30 Jun 2014 06:16:15 GMT

Dear Abhay,

You also try his way , if you have datetime field in your Database table....

//Step 1------

MaxData:

LOAD

DATIME

FROM ..\X.qvd(qvd);

//step 2...........

Sorting:

Load

DATIME as MaxDate

Resident MaxData order by DATIME Desc;

Let MaxTimeStamp=Peek('MaxDate',0);

Let MinDate=Peek('MaxDate',-1);

Let MaxTIMESTAMP=Timestamp($(#MaxTimeStamp),'YYYY-MM-DD-hh.mm.ss.ffffff');

Drop Table Sorting,MaxData;

use last variable in your query.

Warm Regards

Vimlesh Gupta

PradeepReddy — Mon, 30 Jun 2014 06:20:51 GMT

As suggested by anand, you can use the 'ReloadTime()' function

ReloadTime() : Returns a time stamp for when the script last finished re-executing.