Loading Multiple Excel with multiple sheets without ODBC connection..??

[Silambarasan1306]

Hi All,

Could Anyone pls help me to load multiple excel with multiple sheets in qlik sense appllication without ODBC driver connection..??

Thanks,

[nabhiram]

Hi Silambarasan Manickam,

To connect without ODBC driver connection, first you need to create new "Folder" connection in Data load editor.

After creating the connection you need to select data to load multiple excel with multiple sheets, click on the select data option

Try the code below

set i = 1;

TableTest:
load * inline
[AA,    BB,    CC,    DD,    EE,    FF,    GG,    HH,    II,    JJ];

For i=1 to 3
Concatenate(TableTest)
LOAD
    AA,
    BB,
    CC,
    DD,
    EE,
    FF,
    GG,
    HH,
    II,
    JJ
FROM [lib://multiple excel/*.xlsx]
(ooxml, embedded labels, table is [Sheet$(i)]);
next

Thanks

Abhiram

[shraddha_g]

Create a folder connection for Folder containing required excel.

And then browse through the excel and its sheets in qliksense

Step 1:

Step 2: Choose excel from list

Step 3: Choose sheets from the list.

I hope it is helpful.

[Silambarasan1306]

Hi,

If i create folder, then i need to call all the files multiple load statement will be occur. That's not workout for my case. i have to load multiple sheets too.

thanks,

[Anonymous]

Hi,

Could you please check below link using single load statement for multiple excel sheets :

Load Multiple excel sheets using For loop

Thanks

[Anonymous]

Hey Abhiram,
The method which you told will concatenate the tables what if i want to see only sheet 1 data ?
Is it possible to store the data and the visualize it if possible ?