Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was wondering if someone could share an example of loading all excel files in a folder done in Qlik Sense without putting it into legacy mode? I've seen some QV examples using an ODBC connector style of doing it, but wanted to see if anyone has an easier / better way to do it around.
Best,
Ali A
I'm thinking more of the ODBC connecting to an Excel sheet part
Ended up doing someting similar which I found here: http://help.qlik.com/en-US/sense/June2017/Subsystems/Hub/Content/Scripting/ScriptControlStatements/F...
Here is the example I ended up with:
sub GetAllExcelSheets (Root)
for each Ext in 'xlsx'
for each File in filelist (Root&'\*.' &Ext)
Table:
LOAD
*
FROM ['$(File)'](ooxml, embedded labels, header is 2 lines); // specific header according to my example, could be different for yours.
next File
next Ext
// for each Dir in dirlist (Root&'\*' )
// call DoDir (Dir)
// next Dir
end sub
call GetAllExcelSheets ('lib://(LibName)')
Hi can you explain what is Root in the example
sub GetAllExcelSheets (Root)
Thanks
Jaya Sharma