Wildcard in Tablename

[Anonymous]

Hi,

I am not finding alot of information on this issue.  I have a group of excel files that i would like to load into Qlikview, however the users maintaining the files are creating the files every day and renaming the sheet as "Damage 06.03.2017" for example.  So this will change daily.  Is there a way to load in a table without using the actual name and rather referring to it as Sheet 2.  Or by using a wildcard of some sort?

Thanks in Advance.

Regards,

[Anil_Babu_Samineni]

May be one solution like below

Files:

Load  RowNo() as ID,

         FileName() is FileName,

         SubField(FileName(),' ', 1) as FileFirstName;

NoConcatenate

Load * Resident Files where WildMatch(FileFirstName,'*Damage*');

Drop Table Files;

And here, The sheet name keep maintain and trying to use same Sheet ID's over there. That is good efficient

[Muthu]

Hi Ruan,

Copy the files in the same path and in the load statement add *.xls instaed of file name.xls

Regards,

Muthu

[Anonymous]

Hi,

I do not have a problem loading the Files, its the actual sheet names that are different.  So the tablenames are different.

Regards,

[Anonymous]

Try this:

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

Hope it helps!