Load multiple excel file in Qlik Sense

[#1]

Hi,

Is it possible to load multiple excel files in Qlik Sense with different file names but same sheet name and field name?

Thanks

[kaushiknsolanki]

Hi,

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

Regards

Kaushik Solanki

[#3]

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.

[kaushiknsolanki]

Hi,

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)

Regards,

Kaushik Solanki

[#5]

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)];

tables:

SQLtables;

DISCONNECT;

FOR i = 0 to NoOfRows('tables')-1

LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39)), chr(36));

Table:

Load * ,

FileBaseName()as FIle,

FileDir() as Dir,

FileName() as File_Name,

'$(sheetName)' as Sheet_name

From $(file)(ooxml, embedded labels, table is [$(sheetName)]);

NEXT i

Next

[jayaseelan]

Hi,

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:

SQLtables;

DISCONNECT;

FOR i = 0 to NoOfRows('Temp')-1

LET sheetName = purgeChar(purgeChar(peek('TABLE_NAME', i, 'Temp'), chr(39)), chr(36));

Table:

Load * ,

FileBaseName()as FIle,

FileDir() as Dir,

FileName() as File_Name,

'$(sheetName)' as Sheet_name

From $(file)(ooxml, embedded labels, table is [$(sheetName)]);

NEXT i

Next

Thank,

[nizamsha]

Hi Kaushik Solanki

How to change according to Qlik Sense Script I tried many ways but it does not work

Regards

Nizam