Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.
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?