Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
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 ?
Paul
If you want to add ex 1 more file, SET vFile4 = '$(vRAWPath)Q_Payment_sdgggdsag';
change LET vNoOfFiles=4;
My Raw data and QVW
Change LET vNoOfFiles=x; x to as many vFilex you have, in Your case 3
If you want to add ex 1 more file, SET vFile4 = '$(vRAWPath)Q_Payment_sdgggdsag';
change LET vNoOfFiles=4;
Hi Staffan
When i add LET before $(vNoOfFiles);
I get error msg :-
Script line error:
for i =1 to let 1
When to put x=3 ?
Paul
here
//==============Hardcodedlist====================
LET vNoOfFiles=3;
set vFile1 = '$(vRAWPath)Q_Payment_KL';
SET vFile2 = '$(vRAWPath)Q_Payment_Penang';
SET vFile3 = '$(vRAWPath)Q_Payment_TID';
//============================================
Hi Staffan
thank you very much , it work fine now,
Paul
Good!
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.
Hi Staffan
Can you advise me on the below :-