topic Loading Missing Files in Qlikview in QlikView

Loading Missing Files in Qlikview

poppypearce — Sat, 16 Nov 2024 21:41:37 GMT

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

Re: Loading Missing Files in Qlikview

lironbaram — Mon, 24 Dec 2018 05:07:22 GMT

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

Re: Loading Missing Files in Qlikview

poppypearce — Fri, 13 Mar 2020 07:01:21 GMT

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