Discussion Board for collaboration on QlikView Scripting.
If memory serves, this is only availble directly in the For each... next script syntax. If you look that up in the QV help, you should find an example.
Hope this helps,
I recieve flat files from our webanalytic system.
It places the files in a new folder - each time is sends a file over
the file below was sent over on August 1, 2011 at 5 a.m.
the file below was sent over on August 2, 2011 at 6 a.m.
I can create a variable to populate the date however I cannot predict the time that the files will be created.
I would like to place a wildcard in place of the timestamp. To be specific, I'm trying to replace the 05.00.00 and the 06.00.00 with a wildcard.
I don't really care what kind of wildcard it is. It simply needs to take the place of the timestamp.
We can use wildcards on filenames however everything I read states that we cannot use wildcards on filepaths..
You should be able to use something like
This will load all the files that match the mask. QV will automatically loop over the files and concatenate the results.
Hope that helps
I'm not 100% sure if that works (I could be wrong here).
If it does work - all good.
If it does not work, try a for each next loop to iterate over all folders and files inside the folders and load the files you want with the standard load statement.
Have a look at the below links, those are very helpful.
http://community.qlik.com/message/3752#3752 - Have a look at the attachment in this post.
thanks for the responses.
This question is not yet answered. I can use a wildcard in the file name but cannot use wildcard in the file path. So my issue is with the file path NOT the file name.