Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmeplease
Creator III
Creator III

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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

qlikmeplease
Creator III
Creator III
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,

qlikdeez
Specialist
Specialist