Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Loading Missing Files in Qlikview

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

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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

View solution in original post

2 Replies
Highlighted
Partner
Partner

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

View solution in original post

Highlighted
Creator
Creator

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