Discussion board where members can get started with Qlik Sense.
Is it possible to load multiple excel files in Qlik Sense with different file names but same sheet name and field name?
Yes you can use the qlikview script given in below link, it will work in Qlik Sense.
Load multiple excel files from Multiple excel sheetsinto QV
Loading Multiple Excel Sheets Dynamically along with file name and sheet name
Thanks for the reply, I had tried it before but it does not load anything. I am trying to Disabling standard mode so that it can run in legacy mode, however when I open the setting.ini, it is a blank page.
In Qlik Sense you might need to modify the script little bit, due to the way the Path is defined in Qlik Sense.
Hope you have done that change. (Create a Library path which is connected to the folder from where you want to get the excel)
I have change to file path to lib connector, but I don't know how to change to ODBC CONNECT32, it saids "connects other than lib connect are not available in this script mode"
//to read each file from the specified folder
FOR EACH file in FileList('Lib://Transport Claim/*.xls');
//In order to get the file information from SQLtables command making use of the ODBC connection format
ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];
FOR i = 0 to NoOfRows('tables')-1
LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));
Load * ,
FileDir() as Dir,
FileName() as File_Name,
'$(sheetName)' as Sheet_name
From $(file)(ooxml, embedded labels, table is [$(sheetName)]);
Try this Example to you case,
FOR EACH file in FileList('C:\Users\HP\Desktop\New folder\2700.xlsx');
ODBC CONNECT32 TO [Excel Files;DBQ=$(file)];Temp:
FOR i = 0 to NoOfRows('Temp')-1
LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'Temp'), chr(39)), chr(36));
Hi Kaushik Solanki
How to change according to Qlik Sense Script I tried many ways but it does not work