Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to make my script after load 1st txt file and don't stop there and load 2nd txt file ?

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

1 Solution

Accepted Solutions
stabben23
Partner - Master
Partner - Master

If you want to add ex 1 more file, SET vFile4 = '$(vRAWPath)Q_Payment_sdgggdsag'; 

change LET vNoOfFiles=4;

View solution in original post

8 Replies
paulyeo11
Master
Master
Author

My Raw data and QVW

stabben23
Partner - Master
Partner - Master

Change LET vNoOfFiles=x; x to as many vFilex you have, in Your case 3

stabben23
Partner - Master
Partner - Master

If you want to add ex 1 more file, SET vFile4 = '$(vRAWPath)Q_Payment_sdgggdsag'; 

change LET vNoOfFiles=4;

paulyeo11
Master
Master
Author

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

stabben23
Partner - Master
Partner - Master

here

//==============Hardcodedlist====================
  LET vNoOfFiles=3;
set vFile1 = '$(vRAWPath)Q_Payment_KL';
SET vFile2 = '$(vRAWPath)Q_Payment_Penang';
SET vFile3 = '$(vRAWPath)Q_Payment_TID';
//============================================ 

paulyeo11
Master
Master
Author

Hi Staffan

thank you very much , it work fine now,

Paul

stabben23
Partner - Master
Partner - Master

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.