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: 
Not applicable

Wildcards in Filepath

Does anyone know how to use a wildcard in the file path (not the file name)?

8 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Can you please tell us what wildcard you want to use.

    Please explain in detail with example.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Or
MVP
MVP

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,

Or

Not applicable
Author

I recieve flat files from our webanalytic system.

It places the files in a new folder - each time is sends a file over

For example


the file below was sent over on August 1, 2011 at 5 a.m.
\\webanalyticserver\2011-08-01 05.00.00\datafile.xlxs

the file below was sent over on August 2, 2011 at 6 a.m.
\\webanalyticserver\2011-08-02 06.00.00\datafile.xlxs


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..

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

You should be able to use something like

\\webanalyticserver\2011-08-01*.qvd

This will load all the files that match the mask. QV will automatically loop over the files and concatenate the results.

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks! I’ll give it a try

magavi_framsteg
Partner - Creator III
Partner - Creator III

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.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Have a look at the below links, those are very helpful.

     http://community.qlik.com/docs/DOC-1306

     http://community.qlik.com/message/3752#3752   - Have a look at the attachment in this post.

    http://qlikviewmaven.blogspot.com/2008/09/loading-all-of-files-from-folder.html

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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.

thx