In my script I only want to read the files that ends with AVA. How can I solve this? Thanks.
Use a wildcard.
Simple load *youstring ??
another solution (having performance disadvantages because all files are loaded prior to filtering) but enabling other string operations on the filename also:
Where FileBaseName() like '*AVA';
hope this helps
I can't get it to work :/ This is my script and I get the following error messages.
Remove the comma after [SEL0004]
That doesn't belong. That's why you're getting the red squiggly underlining. And the other errors.
I still get the red underline and errors after removing the comma.
Oh you also need a comma after the *
... and the semicolon between .xls and where ...
So basically create a working LOAD statement first (e.g. using the file load wizard) and apply the "*" or "where" solution afterwards.
It still doesn't work and the end of the last row is red so something is wrong there. Do you see what it is?
The problem is now solved. I had some issue with the format of the files I wanted to load. Thx for your help!
please close your thread if your question is answered:
Qlik Community Tip: Marking Replies as Correct or Helpful
Retrieving data ...