FYI, You must create one connection using folder. Let's assume your folder structure like
You need to create connection first till here(\\ServerName\Folder\Folder1\) using the name like (Connection Name). Then, Again you must try pull data using the same connection
And moreover, You said that you need to pull data from SQL as well. For that you need to connect using SQL formalities like How to create SQL Connection Creation for Qliksense
Thank you for this. I already pull from a SQL database, and i've pulled from excel files. I have just never pulled from an excel file from multiple sheets.
Some of the solutions people gave me to pull all the sheets in the excel file was to use a script that uses the function SQLTables and an ODBC Connection to the excel file. I think SQLTables is a function that lists the sheetnames via the ODBC connection - so i need to start by fixing/creating this connection before using the excel sheets script from other threads
I will try and create the connection, wish me luck
Create a named ODBC connection in ODBCAD32 (you may need the 32 bit version in the SysWow64 folder, not the 64 bit version in System32 -- these aren't typos).
The add the connection in Sense in the usual way. Finally use SQLTables to get the table details. Something like:
// Connection to ResourcePlan.xls
LIB CONNECT TO 'TestExcel32';
LOAD 0 as Dummy AutoGenerate 0;
For i = 0 To NoOfRows('TABLES')
Let vTable = Peek('TABLE_NAME', i, 'TABLES');
(biff, embedded labels, table is '$(vTable)');