Loading Missing Files in Qlikview

[poppypearce]

Hi,

Requirement is to load the Excel to QVD on Daily Basis. So we need to do the Incremental Load As usual, but at the same time there will be some missing files which should also be append to the QVD, example 4th Dec & 5th Dec excel files were not received, but it will be received on 24th Dec, so on 24th Dec, we need to load the missing files of 4th & 5th Dec along with 24th Dec file. please help, how can we load the missing files??

Excel file naming convention is like ABC_DDMMYYYY.xls.

Regards,

Poppy

[lironbaram · Accepted solution]

hi 

assuming you load the filename into your QVD ; 

then you can use the not exists function 

for eaxmple :

///////////////loading existing file names from qvd /////////////////

existsFiles:

load distinct fileName 

from Qvd ;

/////////////////////loading missing files /////////////////////////////

IncrementalData:

load *,

          filename() as fileName

from file*

where not exists(fileName,filename());

load  * 

from QVd

[poppypearce]

Tried this solution but it loads only 1 record from the file..