topic Re: Scripting wildcard so i can insert multiple files within a folder? in QlikView

Scripting wildcard so i can insert multiple files within a folder?

Mon, 11 Feb 2013 08:42:33 GMT

I have a folder that has data labeled by years. The data has the same tab names and collumn labels. I want to be able to insert all of these excel files into QliView on one script. Isnt there a way to select the file path to the folder where the files are located and then evnter a common word in the files name of the files i want to insert and then add a wild card to get all the files with that word in the title? If so, how can i do that? what is that wildcard? Example(

Product - Process Archive FY'09-FY'10.xls

can i just delete back to (Product) and then add an (*)

Product* does anyone have an example of creating a script for this?

Thanks!

Re: Scripting wildcard so i can insert multiple files within a folder?

Mon, 11 Feb 2013 08:58:11 GMT

Hi,

Your idea is right. You can use Product* to get all the excel files that have file names that starts with Product. You can create a variable to handle the directory.

Regards,

Janzen

Re: Scripting wildcard so i can insert multiple files within a folder?

Gysbert_Wassenaar — Mon, 11 Feb 2013 08:59:45 GMT

Yes, you can use a wildcard like that

Table1:

load *

from Product*.xls

(biff, embedded labels);

If you want to specify a directory look at this document or this discussion.

Re: Scripting wildcard so i can insert multiple files within a folder?

Mon, 11 Feb 2013 09:04:09 GMT

also, if im now getting a script error and states ( Field not found-<Defect Description> does that mean that in one of the files that Defect Description is not in that file?