Rikab,
There are different ways of doing Incremental load, asaan tareeqa hai kai.... humain ek loop lagana hota hai magar iss main ek dynamic variable hota hai (for each File in filelist ('$(path)CHT*.dat')), check out some of my simple example:
if required tu.... pehlai ek configuration file hum bana saktai hain.... and define some variable here if you need it i.e. configuration.txt
-------Configuration.txt-----------
let CurrentDay= day(now()-1) ;
let CurrentMonth= 06;
let CurrentYear= 2010 ;
let mn='06Jun10';
let prepath='C:\QlikView';
next step is u need to create a qvw file for incremental load / generate incremental qvd.
$(include=Configuration.txt);
let path = '$(prepath)' & '\Input\' & '$(mn)' & '\Account\' ;
let Outputpath= '$(prepath)' & '\Output\' & '$(mn)' & '\Account\QVDs\' ;
for each File in filelist ('$(path)CHT*.dat')
let CurrentFileName = right('$(File)', (len('$(File)') - len('$(path)')) ) ;
let LoadDate = mid('$(CurrentFileName)', 7,2) ;
load
'$(File)' as FileName,
FileTime( '$(File)' ) as FileTime,
FileSize( '$(File)' ) as Size
autogenerate (1);
Txn:
LOAD
@1:3 as TxnCode,
@4:22 as Acc_no,
@46:51 as Purchase_Date,
@52:63 as Destination_Amount,
@64:66 as Destination_Currency_Code,
@67:106 as Source_Amount,
$(LoadDate) as LoadDate
FROM [$(path)$(CurrentFileName)] (ansi, fix, no labels, header is 27, record is line);
Next File ;
store Txn into $(Outputpath)Txn_$(mn).qvd ;
//store CH$(CurrentFileName) into $(Outputpath)CH$(CurrentFileName).qvd ;
drop table Txn;
path variable use to take input file and outputpath is using for output qvd file. iss main hota ya hai kai daily basis pai transaction ki ek new file aa jati hai jisai hum TXN_mn.qvd main daal daitai hain simple. try the above code, i hope it would help u
Shumail
