topic Re: Load QVDs into QlikView based on last modified date in QlikView

Load QVDs into QlikView based on last modified date

Anonymous — Wed, 19 Jul 2017 09:10:32 GMT

Hello All,

I have monthly QVDs from 2016 to till date.

Data is stored into QVD based on Month. So I have 19 monthly wise QVDs.

I am showing the data from 2016 till date on the QlikView Application So I am loading the data from QVDs using * to load all the QVDs into QV.

Only current month and previous months QVDs only will be refreshed everyday.

In this case I don't have to load the data from all the historical QVDs into QV Dashboard everyday. But I should show the data from 2016 till date on the QV Application.

Only current and previous months QVD should load. So I can reduce the reload time.

Can anyone suggest me how to achieve this?

Thanks,

Nisha

Re: Load QVDs into QlikView based on last modified date

tresB — Wed, 19 Jul 2017 09:29:11 GMT

You may try with Partial Reload ‒ QlikView

Re: Load QVDs into QlikView based on last modified date

Siva_Sankar — Wed, 19 Jul 2017 09:46:02 GMT

Incremental Load in Qlikview - Sources

Re: Load QVDs into QlikView based on last modified date

techvarun — Wed, 19 Jul 2017 10:31:26 GMT

Try this script

for each File in filelist ('C:\My Documents\Test\*.TXT')

Folder:

Load '$(File)' as Name,

FileTime( '$(File)' ) as FileTime,

Filename() as Source

autogenerate 1;

next File

LatestFile:

first 2

Load

Name,

FileTime,

1 as dummy

Resident Folder

Order By FileTime DESC;

drop table Folder;

Source : Load the latest file of a folder

//Code Modified to pick the latest two files from the folder//