Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Wildcard in Tablename

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,

4 Replies
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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Muthu
Partner - Creator III
Partner - Creator III

Hi Ruan,

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

Regards,

Muthu

Anonymous
Not applicable
Author

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