Discussion Board for collaboration related to Qlik Education.
I have a excel sheet that i receive from my client on a daily basis that i have to load on to qlikview
But the problem is that each day that sheet has a different name
please tell me that what changes should i make to the loading logic so that i need not change the sheet name daily
I think the following discussion will help you on that
Re: Loading from multiple Excel files and multiple sheets
Tha basic idea is to create an ODBC connection to get all the sheet names and then loop through them to get the data.
you can use a script similar to this:
for each Ext in 'qvw', 'qva', 'qvo', 'qvs'
for each Dir in dirlist ('$(Root)'&'\*')
for each File in filelist (Dir&'\*.' &Ext)
'$(File)' as Name,
FileSize( '$(File)' ) as Size,
FileTime( '$(File)' ) as FileTime,
Subfield('$(File)', '\', 1+SubStringCount('$(File)', '\')) as Fichero,
left('$(File)', index('$(File)', '\', -1)) as Directorio
If this is what you wanted Sunny, could you please close this discussion by selecting the correct/helpful answer?