Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Tried this solution but it loads only 1 record from the file..