Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

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!

3 Replies
Not applicable

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

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?

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.


talk is cheap, supply exceeds demand
Not applicable

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

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?

Community Browser