Incremental script

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

Can anyone help me in understanding following incremental load script.

SET vLastExecTime = 0; // resetting vLastExecTime

LET vLastExecTime = timestamp(if(isnull(QvdCreateTime('$(vQVDPath)ReloadHistory.QVD')), 0, ConvertToLocalTime(QvdCreateTime('$(vQVDPath)ReloadHistory.QVD'), 'GMT', 1)), 'YYYY-MM-DD hh:mm:ss');

LET vExecTime = timestamp(UTC(), 'YYYY-MM-DD hh:mm:ss');

LET vTodaysDate = today();

//For the 1st reload, this section will be skipped.

LET FirstReload = isnull(QvdCreateTime('$(vQVDPath)ReloadHistory.QVD'));

if Not $(FirstReload) then

// Read Reload History Data

ReloadHistory:

Load

No,

[Last Reload Ended],

[Reload Started]

FROM $(vQVDPath)ReloadHistory.qvd (qvd);

end if

ReloadHistory:

LOAD

RowNo() as No,

'$(vLastExecTime)' as [Last Reload Ended],

'$(vExecTime)' as [Reload Started]

Autogenerate(1);

STORE * FROM ReloadHistory INTO $(vQVDPath)ReloadHistory.qvd;

Regards

Manu

topic Incremental script in QlikView

Incremental script