Discussion board where members can get started with Qlik Sense.
Hello Michal, Community,
I need to load multiple xlsb files to Qlik SENSE.
I use the Microsoft Excel ODBC Driver as shown in above screenshots.
With the above driver, I HAVE TO select a SINGLE xlsb file as database. Eg. Test_01.xlsb
Connect - Load - Disconnect, ok
Now I select another xlsb file (Script editor, Select Data, Select a Database, E.g Test_02.xlsb
Connect - Load - Disconnect , ok
However, if I want a LOOP load of the files, I cannot specify the FROM statement:
In the loop. I do use Connect and Disconnet,
Connect is like this: LIB CONNECT TO 'Excel Files';
But to the contrary of ODBC Connect in QlikView, I cannot specify nowhere in the loop the database e.g. the xlsb file
(QlikView: ODBC CONNECT32 TO [Excel Files;DBQ=$(vFileName)];) This does not work in Sense
So can you guys help with how to load MULTIPLE xlsb files to SENSE? Thanks a lot!