how to load multiple excel sheets in single file in qliksense

[daisy1438]

Hi,

  I have the requirement of loading multiple excel file with multiple sheets..

I have Excel files in folder

In file1 excel file I have three sheets  sheetA, sheetB, sheetC

In file 2 excel file I have three sheets  sheetD, sheetE, sheetF

In file 3 excel file I have three sheets  sheetG, sheetH, sheetI

I have this three excel file in one folder...

I want to load all Excel file at a time and store into a QVD..

I want to do it in Qliksense...can any one give me solution for my requirement..

[Prashant_Naik]

Hi,

This might help you

Loading Multiple Excel Sheets Dynamically along with file name and sheet name 

Regards,

Prashant

[Taoufiq_Zarra]

if the files have the same datafield

Data:

LOAD 
     *
FROM
[.\Folder\file1.xlsx]
(ooxml, no labels, table is sheetA);

LOAD 
     *
FROM
[.\Folder\file1 .xlsx]
(ooxml, no labels, table is sheetB);


LOAD 
     *
FROM
[.\Folder\file1 .xlsx]
(ooxml, no labels, table is sheetC);




LOAD 
     *
FROM
[.\Folder\file2.xlsx]
(ooxml, no labels, table is sheetD);

LOAD 
     *
FROM
[.\Folder\file2 .xlsx]
(ooxml, no labels, table is sheetE);


LOAD 
     *
FROM
[.\Folder\file2 .xlsx]
(ooxml, no labels, table is sheetF);


LOAD 
     *
FROM
[.\Folder\file3.xlsx]
(ooxml, no labels, table is sheetG);

LOAD 
     *
FROM
[.\Folder\file3 .xlsx]
(ooxml, no labels, table is sheetH);


LOAD 
     *
FROM
[.\Folder\file3 .xlsx]
(ooxml, no labels, table is sheetI);

STORE Data into .\QVD\DATA.qvd (qvd);

[Kushal_Chawda]

check this

https://community.qlik.com/t5/QlikView-Documents/Dynamically-Loading-Multiple-Excel-Files/ta-p/14790...