I have this script from Staffan
When i run , it only load the first file and stop load the second file .
Can some one advise me where go wrong ?
My Raw data and QVW
If you want to add ex 1 more file, SET vFile4 = '$(vRAWPath)Q_Payment_sdgggdsag';
change LET vNoOfFiles=4;
thank you very much , it work fine now,
in the best of a qlikview world is if you can "point" the files out in another way then a hardcoded list.
ex you can use timestamp when the files was created or the sufixname.
if you want to add 100 files, then you need to add all in the script.
Can you advise me on the below :-
Re: How to modify my script , When i need change my raw data file name,I don't need to edit QV script ?
Change LET vNoOfFiles=x; x to as many vFilex you have, in Your case 3
When i add LET before $(vNoOfFiles);
I get error msg :-
Script line error:
for i =1 to let 1
When to put x=3 ?
//==============Hardcodedlist==================== LET vNoOfFiles=3; set vFile1 = '$(vRAWPath)Q_Payment_KL'; SET vFile2 = '$(vRAWPath)Q_Payment_Penang'; SET vFile3 = '$(vRAWPath)Q_Payment_TID'; //============================================
Retrieving data ...